CREATE OR REPLACE PROCEDURE drop_table IS CURSOR myCursor IS SELECT table_name FROM user_tables; strSQL user_tables.table_name%type; BEGIN OPEN myCursor; FETCH myCursor INTO strSQL; WHILE myCursor%FOUND LOOP EXECUTE IMMEDIATE 'DROP TABLE ' || strSQL || ' CASCADE CONSTRAINTS'; FETCH myCursor INTO strSQL; END LOOP; CLOSE myCursor; END; /
CURSOR myCursor IS SELECT table_name FROM user_tables;
strSQL user_tables.table_name%type;
BEGIN
OPEN myCursor;
FETCH myCursor INTO strSQL;
WHILE myCursor%FOUND LOOP
EXECUTE IMMEDIATE 'DROP TABLE ' || strSQL || ' CASCADE CONSTRAINTS';
FETCH myCursor INTO strSQL;
END LOOP;
CLOSE myCursor;
END;
/
可以直接drop user xxx cascade
再重新创建用户