Frequently Asked Question

select instance_name from v$instance;

select username from dba_users;

drop user pubuser cascade;
drop user privuser cascade;
drop user pxrptuser cascade;
drop user bgjobuser cascade;
drop user admuser cascade;

select tablespace_name from dba_tablespaces;

drop tablespace PMDB_DAT1 including contents and datafiles;
drop tablespace PMDB_NDX1 including contents and datafiles;
drop tablespace PMDB_LOB1 including contents and datafiles;
drop tablespace PMDB_PX_DAT1 including contents and datafiles;