2007. 11. 29. 14:12

오라클 세션 관리이지 말입니다.

http://radiocom.kunsan.ac.kr/lecture/oracle/what_is/session.html


생성

CREATE USER xxxxx IDENTIFIED BY xxxxx DEFAULT TABLESPACE xxxxx
TEMPORARY TABLESPACE xxxxx;

권한

GRANT RESOURCE, CONNECT TO xxxxx;
GRANT EXP_FULL_DATABASE, IMP_FULL_DATABASE TO xxxxx;

IMPORT

$imp userid=xxxxx/xxxxx file=c:\full.dmp full=y log=c:\log.log