oracle:dba

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- oracle:dba [2018/10/15 04:04] – taekgu
+++ oracle:dba [2025/04/15 10:05] (현재) – 바깥 편집 127.0.0.1
@@ 줄 1: / 줄 1: @@
-===== DBA =====
+====== DBA ======
-.DB 사용자 알아보기.
+  * [[white:h5dbimport|H5 DB Import]]
+  * [[oracle:user|Oracle User관리]]
+  * [[oracle:dblink|Oracle DB Link]]
+  * [[oracle:dba:script|DB Script생성]]
+==== Data Pump Directory확인 ====
+<code sql>
+SELECT DIRECTORY_PATH FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = 'DATA_PUMP_DIR';
+</code>
+==== 1.DB 사용자 알아보기. ====
 <code sql>
 SELECT username, account_status FROM dba_users WHERE username='SCOTT';
@@ 줄 9: / 줄 17: @@
 SELECT * FROM user_role_privs;
 </code>
-.TableSpace목록보기
+==== 2.TableSpace 확인 ====
+<code sql>
+select file_name, tablespace_name
+from dba_data_files;
+select sum(bytes)/1024/1024
+from dba_free_space
+where tablespace_name='H5_DATA'
+;
+</code>
 <code sql>
 SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM DBA_TABLESPACES;
@@ 줄 21: / 줄 40: @@
 create tablespace H5_DATA datafile 'C:\app\virtual\oradata\orcl\H5_DATA.dbf' size 100m;
 create tablespace H5_INDX datafile 'C:\app\virtual\oradata\orcl\H5_INDX.dbf' size 100m;
-</code>
-==== Tablespace생성 ====
-<code sql>
+CREATE tablespace TS_PSBEHR_DAT datafile 'C:\app\virtual\oradata\orcl\TS_PSBEHR_D01.dbf' SIZE 100m;
+CREATE tablespace TS_PSBEHR_IDX datafile 'C:\app\virtual\oradata\orcl\TS_PSBEHR_IDX_01.dbf' SIZE 100m;
 CREATE TABLESPACE H5DATA
     DATAFILE '/u01/app/oracle/oradata/XE/h5data.dbf' SIZE 1024M
     AUTOEXTEND ON NEXT 100M;
-</code>
-<code sql>
 CREATE TABLESPACE H5INDX
     DATAFILE '/u01/app/oracle/oradata/XE/h5indx.dbf' SIZE 1024M
     AUTOEXTEND ON NEXT 100M;
 </code>

oracle/dba.1539576265.txt.gz · 마지막으로 수정됨: 2025/04/15 10:05 (바깥 편집)