1. Home
  2. Support
Article - CS56352

Upgrade Database Schema fails with "ORA-00959: tablespace 'BLOBS' does not exist"

Modified: 06-Sep-2016   


Applies To

  • Windchill PDMLink 10.0 to 10.2

Description

  • Upgrade Database Schema fails with "ORA-00959: tablespace 'BLOBS' does not exist"
  • Custom tablespace have been set up as per CS53387
  • Stack trace reads:
Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00959: tablespace 'BLOBS' does not exist

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
    at wt.tools.sql.SQLCommand.doExecute(SQLCommand.java:98)
    at wt.tools.sql.AbstractCommand.doExecute(AbstractCommand.java:74)
    at wt.tools.sql.AbstractCommand.execute(AbstractCommand.java:56)
    at wt.tools.sql.AbstractListCommand.doExecute(AbstractListCommand.java:78)
    at wt.tools.sql.AbstractCommand.execute(AbstractCommand.java:56)
    at wt.tools.sql.ScriptCommand.execute(ScriptCommand.java:102)
    at wt.tools.sql.AbstractListCommand.doExecute(AbstractListCommand.java:78)
    at wt.tools.sql.AbstractCommand.execute(AbstractCommand.java:56)
    at wt.tools.sql.ScriptCommand.execute(ScriptCommand.java:102)
    at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeCommand(AbstractUpgradeDBHelper.java:356)
    at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeSqlScriptsBatch(AbstractUpgradeDBHelper.java:326)
    at com.ptc.windchill.upgrade.phases.upgradeschema.UpgradeSchema.createNonModeledTables(UpgradeSchema.java:1886)
    at com.ptc.windchill.upgrade.phases.upgradeschema.OracleUpgradeSchemaWorker.batchAllSqls(OracleUpgradeSchemaWorker.java:134)
    at com.ptc.windchill.upgrade.phases.upgradeschema.OracleUpgradeSchemaWorker.execute(OracleUpgradeSchemaWorker.java:76)
    at com.ptc.windchill.upgrade.phases.upgradeschema.UpgradeSchema.execute(UpgradeSchema.java:441)
This is a printer-friendly version of Article 56352 and may be out of date. For the latest version click CS56352