-
I have ORACLE Ver. 7.3.
I exported data by using "exp73.exe usename/password file=location" from dos.
When I use "imp73.exe username/password file=location" to import data than messages come "Table already exists Skip table", "import terminated successfully."
I need some help about import this database which replace older database in that user.
Yogesh Bhardwaj
-
Hi,
I assume that you want to replace the old data?
The best bet for this is to truncate the old versions of the tables into which you are importing, and add the 'ignore=y' flag to your import command. If you do not use truncate to remove the old data, then Oracle will import the new data, and attempt to add it to the existing data (you may either get duplicate rows, or errors because of trying to create duplicate rows - depending on uniqueness constraints and indexes).
HTH
David.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|