exp, imp, expdp, impdp...

-- 사용자 비밀번호 변경
 ALTER USER #{user} IDENTIFIED BY #{new_password}

-- Oracle Version
SELECT * FROM V$VERSION; 

-- directory grant 조회
: SELECT *  FROM all_tab_privs  WHERE table_name = #{directory_name};
-- directory 조회
: SELECT * FROM DBA_DIRECTORIES; 
-- user 조회
: SELECT * FROM DBA_USERS;
-- user 권한 조회
: SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = #{user};

-- 테이블상의 트리거를 확인
: SELECT TRIGGER_NAME, TABLE_NAME, STATUS FROM USER_TRIGGERS WHERE TABLE_NAME = #{table_name};
-- 해당 트리거를 disable함
: ALTER TRIGGER #{trigger_name} DISABLE;
-- 해당 트리거를 ENABLE함
: ALTER TRIGGER #{trigger_name} ENABLE;


--expdp, impdp 방식
-- expdp impdp 권한 주기 ==> 읽기, 쓰기
: GRANT READ,WRITE on directory DATA_PUMP_TEST to #{user}
: REVOKE READ,WRITE on directory DATA_PUMP_TEST FROM #{user}

-- 테이블 추출 rows=n 테이블만 추출 rows=y 데이터와 같이 추출
: expdp #{id}/#{password} DIRECTORY=#{directory} DUMPFILE=#{dmp} LOGFILE=#{log} tables=#{table} rows=y
-- 테이블 삽입 
: impdp #{id}/#{password} DIRECTORY=#{directory} dumpfile=#{dmp} LOGFILE=#{log} remap_schema=#{export_user}:#{import_user}
: impdp #{id}/#{password} tables=#{table_name} DIRECTORY=#{directory} dumpfile=#{dmp} LOGFILE=#{log} 

--exp, imp 방식

--exp, imp 외부 dmp 파일 위한 권한 주기 

GRANT IMP_FULL_DATABASE TO #{user};
GRANT EXP_FULL_DATABASE TO #{user};

: exp #{id}/#{password} file=#{dmp} tables=#{table} log=#{log}
: imp #{id}/#{password} file=#{dmp} tables=#{table} fromuser=#{export_user} touser=#{import_user}