Re: Transferring data between Oracle systems.

Kevin.Gurney_at_prgx.com (KG) wrote in message news:<59ac7bfb.0303260125.21f60ec4_at_posting.google.com>...
> Hi,
>
> I've had a request from a client, where they wish to provide us with
> either a backup or an export from their database, which then becomes
> our "opportunity"
> to find a way to restore.
>
> I need some advice on how to go about this, what the pitfalls are if
> any, places to look to research this etc..
>
> In particular what problems are there with:
> Transfer between different operating systems
> Transfer between different versions of Oracle (ie.
> enterprise/developer etc.)
> Importing an exported database
> Restoring a backup from a different machine.
>
> Any help/pointers in the right direction would be greatly appreciated.
>
> Regards,
> Kevin

Kevin, try accepting an export file and then test building a database from it. Make sure all exp file transfers via FTP use binary transfer mode. You can use the show and indexfile options of imp to get the code: imp show=y or indexfile=name. Build a database with appropriate tablespaces and run the import, check the log, and then access the data.

Warning you can generally export from an older version and import into a newer version, but it doesn't work the other way. Export using the older version even if it requires performing a remote export. Some features may not be supported if the Oracle versions are too far apart.

How wise this is depends on the circumstances and expectations of the parties involved.

HTH -- Mark D Powell -- Received on Wed Mar 26 2003 - 09:16:19 CST