출처 : http://thlife.net/557
http://jonelove.tistory.com/entry/Oracle-XE-%EC%9B%B9-%ED%8F%AC%ED%8A%B8-8080-%EB%B3%80%EA%B2%BD%ED%95%98%EA%B8%B0
테이블 스페이스 생성
CREATE TABLESPACE user1_data
DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\USER1_DATA' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE 1024M;
오라클 계정 추가, 수정, 삭제
계정 추가
create user user01 identified by user0110
default tablespace user1_data temporary tablespace temp;
권한 부여
grant connect, resource to user01;
grant dba to user01;
계정 삭제
drop user user01 cascade;
암호 변경
alter user user01 identified by user0111;
관리자용 8080 포트 변경
현재 포트 확인
SELECT dbms_xdb.getHttpPort() FROM DUAL;
포트 변경
EXEC DBMS_XDB.SETHTTPPORT(9090);
백업
exp user01/user01@ubitech owner=user01 statistics=none file=user01.dmp
복원
출처 : http://www.rudaks.co.kr/bbs/view.jsp?seq=1965&bbs=db&PageNo=1
D:\>imp user01/user01 full=y fromuser=user01 touser=user01 file=user01.dmp
Export file created by EXPORT:V11.02.00 via conventional path
import done in KO16MSWIN949 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
D:\>imp user01/user01 fromuser=user01 touser=user01 file=user01.dmp
