Home › Discussions › Questions & Answers › Missing Tablespace during AD Splice on 11i

Missing Tablespace during AD Splice on 11i

Avatar photoCustomer Questions & Answers 3 replies

When running `adsplice` on our EBS 11i environment, we received the error ORA-00959: tablespace ‘APPS_TS_TOOLS’ does not exist. Does this tablespace need to be manually created?

3 replies

  • Support Enginatics

    Yes, this is a dependency issue specific to running `adsplice` on Oracle E-Business Suite version 11i. You need to follow Oracle note 444524.1 and manually create the tablespace `APPS_TS_TOOLS` using a command like: `create tablespace apps_ts_tools datafile ‘tools1.dbf’ size 500m extent management local autoallocate;`

  • If I create this tablespace, should I then rerun `adsplice` from the beginning?

  • Support Enginatics

    Yes, once the prerequisite tablespace is created as `sysdba`, you should rerun `adsplice`.

  • You must be logged in to reply to this post.