We are moving out the database from AIX to Linux platform. The application is R12.1.3 running on Linux and database 11GR2 on AIX 6.1.
We are using transport tablespace for this purpose , the sizes of Ebiz databases are 6 and 8 Terra bytes . Export/import is taking too much time 4-5 days to complete the migration.
I am following this doc ID 1945814.1 and ran script auxttspre.sql which generated XTTS scripts. I found the tablespace CTXSYS01 which the owner is CTXSYS is not included in auexpxtts.dat .I know that CTXSYS will be created on Target database Linux during database creation. What about the objects under CTXSYS, same objects also be created on target or we need to separately export and import CTXSYS objects ?
oracle@# cat auexpxtts.dat
SQL> select count(*),SEGMENT_TYPE,TABLESPACE_NAME
2 FROM DBA_SEGMENTS
3 WHERE OWNER='CTXSYS'
4 GROUP BY SEGMENT_TYPE,TABLESPACE_NAME
5 ORDER BY 2;
61 INDEX CTXSYS01
4 LOBINDEX CTXSYS01
4 LOBSEGMENT CTXSYS01
36 TABLE CTXSYS01