Delete all table in the schema with a single command
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 184.108.40.206.0 - Production
PL/SQL Release 220.127.116.11.0 - Production
CORE 18.104.22.168.0 Production
TNS for Solaris: Version 22.214.171.124.0 - Production
NLSRTL Version 126.96.36.199.0 - Production
Thanks in adv,
Re: Delete all table in the schema with a single command
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 :
select 'drop table ' || table_name || ';' from tabs;
but, I want to delete all tbe objects in the schema.