Yes, i missed that point. Thank you for the correction.
Thiru a écrit dans le message <37DE8D3B.83C0376C_at_excite.com>...
>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 Wed Sep 15 1999 - 02:01:09 CDT
