Sep 22

Issue :-- To import tables from 11g to 10g

Resolution:--

1st Approach

Step 1) login to 10g database
Step 2) tnsping the 11g database
Step 3) Connect to 11g database from 10g database using sqlplus system/<password>@11gdatabase
Step 4) Execute exp command  from 10g database
            exp system/<password> file=tab.dmp tables=schema.T1,schema.T2
Step 5) Import the file tab.dmp on 10g database
Step 6) imp system/<password> file=tab.dmp fromuser=<11g_schema_name>  touser=<10g_schema_name>

2nd Approach

Step 1) login to 11g database .
Step 2) Take expdp of the schema
expdp system/**** schemas=<11g_schema_name> directory=< > dumpfile=< > VERSION=10.2
Step 3) Scp the dmp file to 10g database
Step 4) On 10g database
impdp \'/ as sysdba\' directory=< > dumpfile=< > remap_schema=<11g_Schema>:<10g_schema> remap_tablespace=<11g_tablespace>:<10g_tablespace>,<11g_t2>:<10g_t2>