ADSPLICER - ORA-00959: tablespace 'APPS_TS_TOOLS' does not exist

ORA-00959: tablespace 'APPS_TS_TOOLS' does not existt
This will occurred while executing the SQL statement:

"alter user IZU quota unlimited on APPS_TS_TOOLS"

When u execute the adsplice it check the availablety of APPS_TS_TOOLS Tabalespace .

APPS_TS_TOOLS is used to store the objects for several tools components like SSO , OID , Portal , Discoverer, etc

Before using AD Splice you are required to add this new Tablespace for the new products that are going to be added. If you migrated to the Oracle Applications new Tablespace model you would require to create a new Tablespace APPS_TS_TOOLs manually or you can  use Tablespace creation migration utility before using AD Splicer.

To check the availability of this  tablespace  run:

SQL:>select tablespace_name from dba_tablespaces
          where tablespace_name like 'APPS_TS%' order by 1;

TABLESPACE_NAME
APPS_TS_ARCHIVE
APPS_TS_MEDIA
APPS_TS_NOLOGGING
APPS_TS_QUEUES
APPS_TS_SEED
APPS_TS_SUMMARY
APPS_TS_TX_DATA
APPS_TS_TX_IDX
APPS_TS_TX_INTERFACE

9 rows selected.


Then  create the New Tablespace  APPS_TS_TOOLS :

SQL:>connect as SYSTEM

SQL:>CREATE TABLESPACE APPS_TS_TOOLS
DATAFILE '/*****/****/APPS_TS_TOOLS01.dbf'
SIZE 100 M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024 K
SEGMENT SPACE MANAGEMENT AUTO