0 Replies Latest reply on Aug 9, 2016 11:58 AM by user10922685

    Transport tablespspace CTXSYS objects migration ?

    user10922685

      Hi all,

       

      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
      directory=dmpdir
      metrics=y
      dumpfile=xttsmeta%U.dmp
      filesize=1048576000
      logfile=expxtts.log
      transport_tablespaces=
      APPS_TS_ARCHIVE,
      APPS_TS_INTERFACE,
      APPS_TS_MEDIA,
      APPS_TS_NOLOGGING,
      APPS_TS_QUEUES,
      APPS_TS_SEED,
      APPS_TS_SUMMARY,
      APPS_TS_TOOLS,
      APPS_TS_TX_DATA,
      APPS_TS_TX_IDX,
      ODM,
      OLAP,
      OWAPUB,
      PORTAL,
      TOOLS,
      USERS


      CTXSYS objects

      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