GaramX

1.DB 사용자 알아보기.

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

-- 사용자 Role
SELECT * FROM user_role_privs;

2.TableSpace목록보기

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;