oracle:dba

차이

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

차이 보기로 링크

--- oracle:dba [2018/10/15 04:16] – taekgu
+++ oracle:dba [2025/04/15 10:05] (현재) – 바깥 편집 127.0.0.1
@@ 줄 1: / 줄 1: @@
-===== DBA =====
+====== 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>
@@ 줄 16: / 줄 21: @@
 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;
@@ 줄 28: / 줄 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;
+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;

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