Re: Transportability of an Oracle export file

Export files transported across different Operating Systems need not be necessarly working fine even if they are transferred in Binary mode. You need to set the same RECORDLENGTH parameter in Exp/Imp command lines that are supported in both the OS's..

-Thiru

Michel Cadot wrote:

> John Doe a écrit dans le message <7rl1a0$ojk$1_at_amdint.amd.com>...
> >Hi, I have a rookie question...
> >How transportable is an Oracle export file?
> >I am looking at 2 aspects:
> >1. is it protable from ,say, Oracle on NT to Oracle on Solaris
>
> There is no problem: export file is portable between different OS.
> Remember to transfer the file in binary mode.
>
> >2. can an exported file from Oracle 7.3 database be imported into an 8/8i
> >database?
>
> You have to check if no object or column has a name in the new
> reserved words list.
> There is also some problems if you stored rowids in tables.
>
> Here's 3 queries to check your Oracle 7.3 database:
>
> Select object_name, object_type, owner from dba_objects where object_name in
> ('ACCOUNT’,’NCLOB’,’ARRAY’,’NESTED’,’BFILE’,’NOLOGGING’,’BLOB’,
> ’NOPARALLEL’,’CAST’,’NOREVERSE’,’CFILE’,’NORMAL’,’CHAR_CS’,’NVARCHAR2’,
> ’CHUNK’,’OBJECT’,’CLOB’,’OBJNO_REUSE’,’CLONE’,’OID’,’DANGLING’,’OIDINDEX’,
> ’DATAOBJNO’,’ORGANIZATION’,’DEFERRABLE’,’OVERFLOW’,’DEFERRED’,
> ’PASSWORD’,’DEREF’,’PCTTHRESHOLD’,’DIRECTORY’,’PCTVERSION’,’ENFORCE’,
> ’PRESERVE’,’EXCHANGE’,’PURGE’,’EXPIRE’,’QUEUE’,’EXTENT’,’REF’,’FLOB’,
> ’REPLACE’,’GLOBALLY’,’RETURN’,’HASH’,’RETURNING’,’HASHKEYS’,’REVERSE’,
> ’HEAP’,’SCOPE’,’IDGENERATORS’,’SEG_BLOCK’,’INITIALLY’,’SEG_FILE’,’LIBRARY’,
> ’SKIP’,’LOCKED’,’SYS_OP_NTCIMG’,’LOGGING’,’THAN’,’LOGICAL_READS_PER_CALL’,
> ’THE’,’LOGICAL_READS_PER_SESSION’,’TOPLEVEL’,’MASTER’,’UNLOCK’,
> ’NATIONAL’,’USAGE’,’NCHAR’,’VALUE’,’NCHAR_CS’,’VARYING’) ;
>
> Select table_name, column_name, owner from dba_tab_columns where column_name in
> ('ACCOUNT’,’NCLOB’,’ARRAY’,’NESTED’,’BFILE’,’NOLOGGING’,’BLOB’,
> ’NOPARALLEL’,’CAST’,’NOREVERSE’,’CFILE’,’NORMAL’,’CHAR_CS’,’NVARCHAR2’,
> ’CHUNK’,’OBJECT’,’CLOB’,’OBJNO_REUSE’,’CLONE’,’OID’,’DANGLING’,’OIDINDEX’,
> ’DATAOBJNO’,’ORGANIZATION’,’DEFERRABLE’,’OVERFLOW’,’DEFERRED’,
> ’PASSWORD’,’DEREF’,’PCTTHRESHOLD’,’DIRECTORY’,’PCTVERSION’,’ENFORCE’,
> ’PRESERVE’,’EXCHANGE’,’PURGE’,’EXPIRE’,’QUEUE’,’EXTENT’,’REF’,’FLOB’,
> ’REPLACE’,’GLOBALLY’,’RETURN’,’HASH’,’RETURNING’,’HASHKEYS’,’REVERSE’,
> ’HEAP’,’SCOPE’,’IDGENERATORS’,’SEG_BLOCK’,’INITIALLY’,’SEG_FILE’,’LIBRARY’,
> ’SKIP’,’LOCKED’,’SYS_OP_NTCIMG’,’LOGGING’,’THAN’,’LOGICAL_READS_PER_CALL’,
> ’THE’,’LOGICAL_READS_PER_SESSION’,’TOPLEVEL’,’MASTER’,’UNLOCK’,
> ’NATIONAL’,’USAGE’,’NCHAR’,’VALUE’,’NCHAR_CS’,’VARYING’) ;
>
> select table_name, column_name, owner from dba_tab_columns
> where data_type = 'ROWID';
>
> >
> >Pls send reply to:
> >mail:wk.teoh_at_amd.com
> >
> >Thank you!
> >
> >
Received on Tue Sep 14 1999 - 13:00:28 CDT