====== 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>