|
|
|
|
Re: how to delete all data in all tables in one time ?! [message #304672 is a reply to message #304660] |
Thu, 06 March 2008 01:37   |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
Are you sure ?
SQL> select * from cat;
TABLE_NAME TABLE_TYPE
------------------------------ -----------
TEST_OBJECT TABLE
TEST_ROLES TABLE
TEST_USER TABLE
SQL> delete table test_object;
delete table test_object
*
ERROR at line 1:
ORA-00903: invalid table name
SQL> delete from test_object;
68000 rows deleted.
SQL> rollback;
Rollback complete.
SQL> delete test_object;
68000 rows deleted.
To be honest I thought for a while and said hang on it doesn't look like a right syntax.
Regards
Raj
|
|
|
|
|
|
|
|
|
|
Re: sorry for syntax error [message #304748 is a reply to message #304704] |
Thu, 06 March 2008 08:23  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Please, please stop using OraFAQ as your first option to turn to whenever you run into a problem.
The docs and Google should really be higher on your list. I am pretty sure that there are plenty of relevant hits to be found on this error.
Remember, we want to help you, but we won't do your work for you or solve your problems for you. You will have to do that yourself in the end.
|
|
|