Home » RDBMS Server » Server Utilities » Re: Import Problems
Re: Import Problems [message #368061] Fri, 11 February 2000 09:11
Thomas
Messages: 67
Registered: September 1999
Member
Hi Markus,
run catalog.sql, catproc.sql and catexp.sql as user sys and try again.
If this doesn't help and the database is not TOO
big, I would try to insert it into a new one.
The problem is that sometimes constraints get violated in the database (not a DB Problem, a design or Programmer-Problem) - someone disabled a constraint, inserted data and enabled it again.
Now Oracle exports the hole stuff, creates the
constraint in the new (or old) database BEFORE the import is done and will NOT insert the wrong data again.
If nothing helps, you will be forced to disable the constraint SYSTEM.BROWSER_DOCS_IDX before export.

hope that helps,

regards thomas
Previous Topic: Re: Export File Size Limits?
Next Topic: Export Question !
Goto Forum:
  


Current Time: Tue Apr 16 06:49:32 CDT 2024