In production how to drop the table defined in specific schema?

 

In production how to drop the table defined in specific schema?

Drop table command does not work in .sql file or .adh (adhoc) file?

So we need to write the drop command in .grt file (Grant File)

Drop table schema.tablename;

Save the file as .grt

By executing this file will drop the table as well removes in dba_objects table.