GaramX

현재 위치: home » oracle » dba

추적: • last_day • hint • dba • gradle • update_join • css

oracle:dba

차이

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

차이 보기로 링크

--- oracle:dba [2024/02/24 15:40] – taekgu
+++ oracle:dba [2025/04/15 10:05] (현재) – 바깥 편집 127.0.0.1
@@ 줄 1: / 줄 1: @@
+====== DBA ======
+  * [[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';
+</code>
+<code sql>
+-- 사용자 Role
+SELECT * FROM user_role_privs;
+</code>
+==== 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;
+select name from v$controlfile;
+select file_name from dba_data_files;
+select group#,member from v$logfile;
+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;
+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;
+CREATE TABLESPACE H5INDX
+    DATAFILE '/u01/app/oracle/oradata/XE/h5indx.dbf' SIZE 1024M
+    AUTOEXTEND ON NEXT 100M;
+</code>