-
Import Data Problem
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,
when u are importing using imp73 username=username/password file=location u will get error if the objects that u are importing exists in the database so try to use this command
imp73 username=username/password file=location ignore=y
try this out
suren
-
import
imp73 username=username/password file=location ignore=y
Ignore = y option ignores the create error messages and inserts all the rows into the existing tables..
But How can we import into existing tables and overwrite old rows with new rows which is in the dump file(import file).
Regards
Saravana
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
|