GaramX

1.DB 사용자 알아보기.

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

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;