How to do import and export? [message #71376] |
Thu, 24 October 2002 08:49 |
BABU SRSB
Messages: 42 Registered: June 2002
|
Member |
|
|
Hai,
i am new to this import an export operations. we have 2 DataBases.
I want to upload the data of 2 tables from 1st database to 2nd database.
The 2 tables already existed in both databases. But the records in 1st database is more than second database.
Can any one suggest the way how to do this operation Please.
Urgent reply will be appreciatable.
Regards,
Babu.
|
|
|
Re: How to do import and export? [message #71387 is a reply to message #71376] |
Fri, 25 October 2002 02:27 |
B
Messages: 327 Registered: August 1999
|
Senior Member |
|
|
set ORACLE_SID ( & ORACLE_HOME ) to use DB_SOURCE
use ( assume that user is the owner of the tables )
exp user/password FILE='YOUR_DUMP' LOG='YOUR_LOG'
tables='table1,table2' consistent=Y rows=y
set ORACLE_SID ( & ORACLE_HOME ) to use DB_DEST
Truncate table1 and table2 is U don't want the old data
and use ( user=owner of tables ! )
imp user/password FILE='THE_DUMP_U've DONE' LOG='YOUR_LOG' commit=y rows=y tables='table1,table2'
Should work ... if not tell me
|
|
|
|