Oracle 11g Datenbank, 9i Client exportieren.
In 11g Datenbank: | ||
SYS AS SYSDBA anmelden. | ||
View EXU9DEFPSWITCHES ändern: |
||
CREATE OR REPLACE VIEW exu9defpswitches (compflgs, nlslensem ) as SELECT a.value, b.value FROM sys.v$parameter a, sys.v$parameter b WHERE a.name = 'plsql_compiler_flags' AND b.name = 'nls_length_semantics'; zu CREATE OR REPLACE VIEW exu9defpswitches (compflgs, nlslensem ) as SELECT a.value, b.value FROM sys.v$parameter a, sys.v$parameter b WHERE a.name = 'plsql_code_type' AND b.name = 'nls_length_semantics'; |
||
In 9i Client: In Datei "%ORACLE HOME%NETWORK/ADMIN/tnsnames.ora" von 11g DB "SID" eintragen. exp userid=username/password@SID file=PFAD\USERNAME.DMP log=PFAD\USERNAME.log |