Tag Archives: Oracle exp and imp: oracle9i to 11g

Oracle exp and imp: oracle9i to 11g

Setp — 1 ========== Set the same character on source server: ======================================== In source database export NLS_LANG=AMERICAN_AMERICA.US7ASCII Do actual export(exp parfile=exp.par) Setp — 2 ========== Exporting the data from source database: ======================================== exp system/system123 file=NAS30.dmp log=NAS30.log owner=NAS30 buffer=100000000 grants=y rows=y … Continue reading

Posted in Uncategorized | Tagged , , , | 11 Comments