-
import..
hi
I have full export dump file taken in 8i on win 2k. Now i import
into my test database with the following command
> imp system/.... file=c:\expdat.dmp log=c:\imp.log ignore=y full=y
rows=y
my import log file shows number of row rejected errors due to duplication , Oracle erros like 2494 and 990 etc.
how can i ignore those errors ?
an immediate reply is appreciated
Prasad
-
Drop the user schema, create it again in the same Tablespace and import...at all if you can afford to drop the user...
"Greatest Rewards come only with Greatest Commitments!"
-
I mean is there all the user schemas already available in the test DB or... is there any data already available in Test Database..??
"Greatest Rewards come only with Greatest Commitments!"
-
sandy,
I don't want to drop the schemas, it will remain in test database
and some data also existed in those schemas.
But,the errors like object already existed,unique key violation ,row rejected errors should n't be existed in import log file.
Prasad
-
Did you truncate the existing tables?
Do you have duplicate values in the other database?
MH
I remember when this place was cool.
-
-
IS the instance you are importing is fresh? If it already has data, they why not try INCTYPE=restore
-Sam
Thanx
Sam
Life is a journey, not a destination!
-
hi
how can we import full exported dump file into existed scemas ?
kindly give the command line parameters..
Thanx in adv
Prasad
-
hi
My test db contains schemas,tables and data of last week. Now I
wish to import data from last week to today with the help of full
export dump file which i have taken from main db.
How can I achieve it ....?
Prasad
-
Hi
You may consider exporting the schema with CONSTRAINTS=N and GRANTS=N parameters. Before importing you may also consider disabling the constraints which may need to be enabled again by cleaning up the data.
When importing have tried IGNORE=Y parameter which will not give error if the object is already created?
Bhaskara
OCP 9i
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
|