| Incremntal Import [message #60390] |
Thu, 05 February 2004 09:07  |
Shariq Tariq
Messages: 15
Registered: February 2004
|
Junior Member |
|
|
I have 10 tables that I am exporting out of a database at the end of each month using a batch file with a command for each table
I use the following syntax
exp uvw/uvw_user FILE=tab1.dmp TABLES=tabletest IGNORE=Y
How can I incremntally import this information into another database
I have tried the following syntax
imp xvw/xvw_user FILE=tab1.dmp TABLES=tabletest IGNORE=Y
but this results in duplication of records in the table
Thanks
Shariq
|
|
|
|
| Re: Incremntal Import [message #60391 is a reply to message #60390] |
Thu, 05 February 2004 11:07  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
incremental export/import functionality is obsolete and NOT RECOMENDED by oracle.
You have to remove the records in the target tables,
prior to import session.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
