Frequently Asked Question

How to empty an existing EPPM Oracle database?
Last Updated 3 years ago

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;

Please Wait!

Please wait... it will take a second!