Delete all table in the schema with a single command
Hi All,
I want to delete all the tables in my schema in a single command / function. I don't have DBA rights for this schema and I have only SQL Plus. I am working on :
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
PL/SQL Release 9.0.1.0.0 - Production
CORE 9.0.1.0.0 Production
TNS for Solaris: Version 9.0.1.0.0 - Production
NLSRTL Version 9.0.1.0.0 - Production
Thanks in adv,
Re: Delete all table in the schema with a single command
Quote:
Originally posted by sonuji_in
I want to delete all the tables in my schema
Want to delete all objects in a schema
Thanks for the co-operation and instant reply....
This procedure worked fine and I was able to delete all the tables :
spool drop.sql
select 'drop table ' || table_name || ';' from tabs;
spool off
@drop
but, I want to delete all tbe objects in the schema.
Thanks,,