Re: Transportability of an Oracle export file

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 14 Sep 1999 11:00:11 +0200
Message-ID: <7rl2s7$10s$1@oceanite.cybercable.fr>

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 - 04:00:11 CDT