How Does Oracle delete all tables under a user?

Www.itpub.netthread-762849-1-1.html 1. Log On As sysassysdba. Run the following statement. Username is the username of the table to be deleted. SELECTDROPTABLE | username |. | TABLE_NAME | CASCADECONSTRAINTS; FROMDBA_ALL_TABLESWHEREOWNERusername

Http://www.itpub.net/thread-762849-1-1.html 1. Log On as sys as sysdba. Run the following statement. 'Username' is the username of the table to be deleted. SELECT 'drop table' | 'username' | '.' | TABLE_NAME | 'cascade CONSTRAINTS; 'FROM DBA_ALL_TABLES where owner = 'username'

Http://www.itpub.net/thread-762849-1-1.html

1. Log On as sys as sysdba. Run the following statement. 'Username' is the username of the table to be deleted.

SELECT 'drop table' | 'username' | '.' | TABLE_NAME | 'cascade CONSTRAINTS; 'FROM DBA_ALL_TABLES where owner = 'username'

After execution, an SQL statement set is generated. Copy the SQL statement. Paste it to the new SQL window. After execution, the table under the user is deleted.