No in our database we don't have any table with the default value of -1.

Can you please tell me the exact cause of this problem?



Or any pre requisites for performing import and export on the database.



Thanks

Purusottam Kaushik



-----Original Message-----

From: Jeff Ferrel
[mailto:oracledba-ezmlmshield-x31393913.[Email address protected]

Sent: Tuesday, May 29, 2007 4:02 PM

To: LazyDBA Discussion

Subject: RE: Import/Export error





Do you have any tables with a default value of -1?



I've seen where a table is modified after the initial database was

created, and then the import/export failed due to this constraint.



On my database, it was only one table; I was able to remove the

constraint in OEM, apply, and then export (which always worked) and then

get a successful import.



Take a look.



Jeffrey C. Ferrel

DMS III

State of Nevada

775.687.9327

[Email address protected]










Oracle LazyDBA home page