Oracle EXAMPLE 테이블 삭제하기

SELECT DISTINCT OWNER FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='EXAMPLE';

OWNER
------------------------------------------------------------
HR
OE
PM
SH
IX

DROP USER HR CASCADE;
DROP USER OE CASCADE;
DROP USER PM CASCADE;
DROP USER SH CASCADE;
DROP USER IX CASCADE;


DROP TABLESPACE EXAMPLE INCLUDING CONTENTS AND DATAFILES;

위로 스크롤