728x90
출처
테이블 스페이스 생성
CREATE TABLESPACE user1_data DATAFILE 'C:\app\bluesanta\product\18.0.0\oradata\XE\USER1_DATA.DBF' SIZE 100M AUTOEXTEND ON NEXT 20M MAXSIZE 1024M;
오라클 계정 추가, 수정, 삭제
계정 추가
create user user1 identified by pwd default tablespace user1_data temporary tablespace temp;
권한 부여
grant connect, resource to user1; grant dba to user1;
계정 삭제
drop user user1 cascade;
암호 변경
alter user user1 identified by pwd2;
관리자용 8080 포트 변경
포트 확인
SELECT dbms_xdb.getHttpPort() FROM DUAL;
포트 변경
EXEC DBMS_XDB.SETHTTPPORT(9090);
백업
exp user01/user01@ubitech owner=user01 statistics=none file=user01.dmp
복원
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
728x90