2007. 11. 29. 14:12
오라클 세션 관리이지 말입니다.
2007. 11. 29. 14:12 in DataBase
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
생성
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