How to remove everything from my schema?

connect via sqlplus and execute:

set heading off

set pagesize 0

set feedback off

set timing off

set time off

set trimspool on

set trimout on

set linesize 100

set echo off

spool t

select 'drop '||object_type||' '||object_name||

decode(object_type,'CLUSTER',' including tables cascade constraints',

'OPERATOR', ' force',

'TABLE',' cascade constraints',

'TYPE', ' force',

'VIEW',' cascade constraints',


from user_objects

where object_type in ('CLUSTER', 'CONTEXT', 'DATABASE LINK', 'DIMENSION',





order by object_type, object_name


spool off


purge recyclebin;

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to create an Oracle Wallet?

In order to secure your domain you need to the following:  We complete all necessary...

Can I use my domain name with Apex?

Absolutely, you will have full ftp/sftp access to the server as well.

Do you support SSL/https with APEX Hosting package?

Yes, we do. We can create temporary ssl certificate and when you are ready for a production you...

How do I send e-mail messages from PL/SQL?

Please follow this greate example: below: ( rem...