Re: exp 7.1.4 -----> imp 7.3.3

From: Al <al_at_work>
Date: Mon, 28 Sep 1998 14:12:38 -0400
Message-ID: <6uojqa$5v63@piper.ncr.pwgsc.gc.ca>

A full export is fairly straight forward. Note that the import process will attempt to create the tablespaces, using the same file names as in your 7.1.4 instance. This will fail if you are running on the same server. The solution is to pre-create the tablespaces.

If you are exporting & importing by user, then you will need to manually define your users. You will also have to define any public synonyms that are used to reference objects owned by the user(s).

Vinay Joshi wrote in message
<01bde959$a2679360$55c015ac_at_klangley.pinnacle.co.uk>...
>Hi,
>I am willing to do an export from oracle 7.1.4 under sco unix and import it
>to oracle 7.3.3 on sco unix .
>Is there any conversion that needs to be done before impORTING into 7.3.3
>
>Any hints/tips/traps appreciated.
>
>Thanks in advance.
>vjoshi_at_pinnacle.co.uk
Received on Mon Sep 28 1998 - 13:12:38 CDT