os

oracle DB exp/imp

littlecarbb 2015. 6. 20. 20:34

exp mcpdb/password file=my_purchase_20150619.dmp tables= MCPDB.MY_PURCHASE

sqlplus '/as sysdba'


grant exp_full_database to mcpdb;


imp userid=QUPUSER/password fromuser=mcpdb touser=qupuser file='/oracle/app/oracle/product/my_purchase_20150619.dmp'

tables=MY_PURCHASE ignore=y


grant exp_full_database to qupuser;


grant dba to qupuser;