-
March 29th, 2023, 09:50 AM
#1
Junior Hostboard Member
How do I drop all tables in Oracle Schema?
How do I drop all tables in Oracle Schema?
-
March 30th, 2023, 10:27 AM
#2
Hostboard Member
Re: How do I drop all tables in Oracle Schema?
The quickest way tp drop all objects within a schema is to drop the schema and recreate it afterwards.
If you only want to drop all the tables create a drop script from the data dictionary and run it.
Views, procedures, functions, and all other inter-schema references will all become invalid.
-
March 31st, 2023, 04:46 AM
#3
Senior Hostboard Member
Re: How do I drop all tables in Oracle Schema?
The fastest way to interact with objects in an Oracle schema is to use the right tool for the job. For example, I use for oracle analyze table and oracle schema compare script , this tool and am completely satisfied with how it works. Since this comprehensive tool has become indispensable for me, it also helps in identifying all the differences between databases.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks