RE: imp.exe full=y imports SYSTEM's objects, violates constraints ...

Right you are!

I was operating under false assumption that parameter ignore=n would somehow stop import process on the very first problem it might stumble on. How silly of me!?

Note to self: DO TEST YOUR ASSUMPTIONS
(especially if you happen to have strong opinion and/or notion on how certain feature should be working or be implemented...)

Thanks,

Branimir

-----Original Message-----
From: David Grosser [mailto:david_oracle-l_at_hotmail.com] Sent: Friday, October 14, 2005 4:15 PM
To: BranimirP_at_cpas.com; oracle-l_at_freelists.org Subject: RE: imp.exe full=y imports SYSTEM's objects, violates constraints...

Your main problem is the IGNORE=Y parameter. Because of that import is attempting to insert data (possibly invalid) into the precreated tables. I'd try the default, IGNORE=N. Then simply ignore the messages indicating that you are attempting to create a table that already exists.

David Grosser

--
http://www.freelists.org/webpage/oracle-l