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

Missing Tablespace during AD Splice on 11i

Avatar photoCustomer April 21, 2020 at 5:23 pm

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support April 22, 2020 at 6:37 am  

      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;`

    • Avatar photoCustomer April 23, 2020 at 2:16 am  

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

    • Support April 24, 2020 at 4:22 pm  

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

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: