Re: Import and export of database?

Your export should work. When importing use ignore=y. Make sure all the tablespaces that were in your source database have already been created in your target database, otherwise import will try to create the tablespace using the path spec from the source database.

I would drop cascade all non-system/sys users from your target database before the import. Let the import recreate everything, this way you don't have to mess around with disabling/enabling constraints.

When you ftp an export file, make sure you set the transfer mode to binary or image. ASCII mode will corrupt the export file.

HTH Ketil Z Malde wrote:

> 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 Mon Jun 29 1998 - 22:04:56 CDT