Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.73K
1 Posted Topic
[CODE] DECLARE table_name VARCHAR2(30); CURSOR usertables IS SELECT * FROM user_tables WHERE table_name NOT LIKE 'BIN$%'; BEGIN FOR next_row IN usertables LOOP EXECUTE IMMEDIATE 'drop table ' || next_row.table_name || ' cascade constraints'; END LOOP; END; [/CODE] save it as a .sql file and run it from oracle sql plus …
The End.