티스토리 뷰
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;
'os' 카테고리의 다른 글
| [Ubuntu] 우분투 GitLab 설치 (0) | 2016.01.26 |
|---|---|
| 우분투 Mysql 설치 및 삭제 - install myslq(ubuntu) (0) | 2016.01.26 |
| Restart NFS in HP UX : How To ? (0) | 2015.01.26 |
| ubuntu 란 (0) | 2014.12.17 |
| ubunt cent os 차이 (0) | 2014.12.17 |