Drop tables from USERS tablesapce
624915Feb 24 2008 — edited Feb 25 2008Hello,
I am newbie to Oracle
1) I want to DROP all tables we created except from those that begins with QNT letters. I tried
BEGIN
FOR T IN (SELECT TABLE_NAME FROM USER_TABLES)
LOOP
EXECUTE IMMEDIATE ('DROP TABLE MyUserName.' || T.TABLE_NAME);
END LOOP;
END;
but I get error
ORA-00933: SQL command not properly ended
or when changing line 4
EXECUTE IMMEDIATE ('DROP TABLE ' || T.TABLE_NAME);
I get
ORA-00903: Invalid table name
What's the problem? How Can I ignore QNTxxxx tables?
2) In addition, I get error when log in to Oracle Schema Manager (though, I log in successfully to SQL WorkSheet)
MGR-02150: an unrecognized database version was encountered.
why?
The server app is 10g, and my computer client app is 8.0.5
Your help will be appreciated,
Ori