[Oracle] Import, Export 방법

• Import 방법

DROP TABLESPACE HANMIPT_DATA INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; 
DROP TABLESPACE HANMIPT_INDEX INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; 

DROP USER hmptwms CASCADE;

CREATE TABLESPACE 테이블명 LOGGING	
DATAFILE 'D:\oradata\orcl\디비명.DBF' SIZE 100M
REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED;

CREATE TABLESPACE 디비명 LOGGING
DATAFILE 'D:\oradata\orcl\디비명.DBF' SIZE 10M
REUSE AUTOEXTEND ON NEXT  5M MAXSIZE UNLIMITED;

create user             aimaster
identified by           admin1004
profile                 default  
default tablespace      적고싶은 테이블명
temporary tablespace    temp
account                 unlock;
grant resource, connect, dba to aimaster with admin option;


imp aimaster/admin1004@orcl rows=y file=C:\db_Back.AI_TEST.dmp full=y

imp hmptwms/hmptsmcdb@SMC_AI rows=y file=C:\teamp.dmp full=y

---

 

• Export 방법

exp aimaster/admin1004@TEST_PARK2 rows=y file=C:\aimaster.dmp