Re: Is the export file of Oracle 8.1.6 portable between Unix/Linux platform?

Hi,

to use the export files is a better way, instaed of using sqlldr. The export file contains not only the data, but also the structure of the schema, views, packages etc.

The export files are portable between Unix/Linux and even Win platforms. You have to distribute them via ftp in the binary mode.

You have also to make sure, that the oracle-server version is the same. I think
it is possible to import an older server's export file into an newer's one, but I'm not sure.

bye
Thomas

Huy Vu <huyv_at_usa.net> schrieb in im Newsbeitrag: 986877723.561965_at_news.aei.ca...
> Hi all,
>
> We have Oracle 8.1.6 database server on Unixware 7.1.1.
> We want to export one schema of this database and bring this export file
 to
> import to other Oracle 8.1.6 databases on different Unix/Linux plaforms as
> Sun Solaris 7 Sparc/Intel, AIX 4.3, HP-UX 10.20, SCO OpenServer 5, RedHat
> 7....
>
> I think that is the quick way to bring the data across of other databases
 on
> different Unix platforms but I'm not sure the export file from UnixWare
 can
> import to other databases on other Unix platforms.
>
> Is the export file of Oracle 8.1.6 portable between Unix/Linux platform?
>
> The alternative of this solution is using sqlldr with control files and
> unload files from Informix export files.
>
> Which solution is more portable?
>
> Thanks in advance for any advise.
>
> DH.
>
>
Received on Tue Apr 10 2001 - 02:03:12 CDT