GaramX

SELECT DIRECTORY_PATH FROM DBA_DIRECTORIES WHERE DIRECTORY_NAME = 'DATA_PUMP_DIR';

SELECT username, account_status FROM dba_users WHERE username='SCOTT';

-- 사용자 Role
SELECT * FROM user_role_privs;

SELECT file_name, tablespace_name
FROM dba_data_files;
 
 
SELECT SUM(bytes)/1024/1024
FROM dba_free_space
WHERE tablespace_name='H5_DATA'
;

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;