My Oracle Support Banner

Why Does auxttspre.sql Script Not Include All the Tablespaces in Transport Scripts ? (Doc ID 2981816.1)

Last updated on OCTOBER 26, 2023

Applies to:

EBS on Oracle Cloud: Provisioning and Administration - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

Why does auxttspre.sql script not include all the tablespaces in transport scripts ?

While following document 'Oracle E-Business Suite 12.2 Platform Migration from On-Premises to Oracle Cloud Using Transportable Tablespaces with Oracle Database 19c (Doc ID 2725558.1)' for Cross Platform Transportable Tablespaces Migrations (XTTS), few tablespaces are getting excluded from the transport scripts. The "auxttswrite_sql" generated does not contain all the tablespaces.

For example, below tablespaces were excluded:
alter tablespace APPLSYSD2 read write;
alter tablespace APPLSYSX2 read write;
alter tablespace APPS_TS_ARCHIVE read write;
alter tablespace APPS_TS_INTERFACE read write;
alter tablespace APPS_TS_MEDIA read write;
alter tablespace APPS_TS_NOLOGGING read write;
alter tablespace APPS_TS_SEED read write;
alter tablespace APPS_TS_SUMMARY read write;
alter tablespace APPS_TS_TX_IDX read write;

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.