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;