Import and export of database?

Hi

Using oracle 7 on Solaris 2.6:

I'm still unable to use the )(&/&/% imp and exp commands to move a database. Why is this so hard?

Making a full dump to expdat.dmp, ftping the file, and then doing an

        imp user/pass file=expdat.dmp full=y ignore=y

doesn't do it, adding a "destroy=y" option doesn't seem to do anything, and setting inctype to complete etc, gives an error.

The error messages I get talks of constraints being violated, here's a sample:

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SLADMIN.XPKSL_PPRJ_TREE) violated

Happens for all rows in the dump. Any suggestions, while I still have some hair left?

~kzm Received on Thu Jun 25 1998 - 09:56:00 CDT