Dear,

Let me work on this. Will update you if found the solution.

Hi Dear,

For 9i, very less features are available.  So i dont think oracle dataguard, RMAN  can be used.  You can check with oracle, regarding the use of goldengate for this purpose.

If nothing is working out, then export import using traditional method is the best solution. But if the size is huge, then it may take lot of time.

Oracle 12.2 has hell lot of features.

You can refer below link – http://dbaclass.com/oracle-12-2/

•  Convert non-partitioned table to partitioned table online
• Datapump New features – Oracle 12.2 Version
• Lock Account Automatically With INACTIVE_ACCOUNT_TIME
• PDB Lockdown Profiles in  Oracle 12.2
• SQL*Plus History In Oracle 12.2
• Long Identifiers In Oracle 12.2
• DBMS_TNS  package for tnsping in  database Oracle 12.2
• Spool CSV In Oracle 12.2
• VARIABLE new feature  in Oracle 12.2
• Move table online in Oracle 12.2
• Read only Partition in Oracle 12.2
• Split partition online oracle 12.2
• Local/Shared Undo mode in oracle 12.2 multitenant database

Admin

Dear,

While dropping a diskgroup in a multi node RAC setup, You should dismount the diskgroup on all the remote nodes, It should be mounted only on the local nodes, where u are running the drop command.

Reference – http://dbaclass.com/article/ora-15073-diskgroup-mounted-by-another-instance/

Regards

Admin

Dear,

The command to move lob segment online is :

alter table DBACLASS.FD_BREL_AUDIT move lob (PAYLOAD) store as SYS_LOB0000100201C00011$$ ( tablespace USERS);

The lob segment name can be obtained from dba_lobs table.

select table_name,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME from dba_lobs where table_name=’FD_BREL_AUDIT’;

Regards