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

Drop the user schema, create it again in the same Tablespace and import...at all if you can afford to drop the user... :o

I mean is there all the user schemas already available in the test DB or... is there any data already available in Test Database..??

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.

Did you truncate the existing tables?
Do you have duplicate values in the other database?

MH

Download OraSchemer at http://www.qwerks.com/download/6578/OraSchemer.exe to help you

IS the instance you are importing is fresh? If it already has data, they why not try INCTYPE=restore

-Sam

hi

how can we import full exported dump file into existed scemas ?

kindly give the command line parameters..


Thanx in adv

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 ....?

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