Good day to all, help me figure out how to copy the entire Oracle database with all the tables for transfer to another server? and is it possible to copy on separate tables (if you can, then tell me how?)? Thank you all very much. Addition: merge the CUSTOMERS and SALESREPS labels from the MILLER schema:

..\.bat-> set nls_lang=russian_cis.ru8pc866 exp.EXE USERID=miller/kolobok@proba TABLES=(CUSTOMERS, SALESREPS) FILE=c:\ORACLE\Tmiller.dat LOG=C:\ORACLE\Tmiller.LOG

Namely, it is not clear what it is kolobok @ proba and with bat files it’s not quite friendly how to start correctly? so .bat-> or even so ... bat-> after save with permission .bat and execute with terminal. Thank.

  • In Google, type "oracle exp". This is the first thing that is firststeps.ru/sql/oracle/r.php?131 - Mike
  • @ Explain addition in question - Ethernets
  • one
    better not put such a stupid nls_lang, try unloading without pointing. You probably have UTF8 in your database and in cp866 it may not be translated one by one. To start the string exp userid=... stupidly in the terminal, try. If you want to automate for the future, then .bat will do it and write it in it. userid = user / password @ server. If the server is local, then the @ server can be omitted - Mike
  • @Mike Server I can ask for ip? For example (@ 192.168.1.3) ??? - Ethernets
  • one
    No, only names listed in tnsnames.ora - Mike

1 answer 1

Use Data Pump Export . Run in the terminal window:

 expdp miller/kolobok@probа tables=CUSTOMERS,SALESREPS directory=datapump_dir dumpfile=Tmiller.dat logfile=Tmiller.LOG

In the directory parameter, you must specify the directory object defined in the database, and not the string with the path to the directory.

PS To avoid conversion of non-ASCII characters, in nls_lang you must specify the encoding installed in the database.