3
Contributors
7
Replies
25
Views
4 Years
Discussion Span
Last Post by tony75
0

standard sql DROP TABLE <tablename>. You may have to drop indices first. DROP INDEX index_name

Edited by Ancient Dragon

0

Thanks Sir
So as I uderstand you I should use sql DROP TABLE and remove my 8 tabeles one after one?
Is there any command to remove all tabels?

0

DROP DATABASE;
but I get this error?

Error starting at line 1 in command:
DROP DATABASE
Error report:
SQL Error: ORA-01586: database must be mounted EXCLUSIVE and not open for this operation
01586. 00000 -  "database must be mounted EXCLUSIVE and not open for this operation"
*Cause:    Attempting to DROP DATABASE when the database is not mounted
           EXCLUSIVE.
*Action:   Mount the database in EXCLUSIVE mode.
0

Did you provide the name of the database. You might want to read Oracle's documentation on that command to see if there are other requirements.

DROP DATABASE <database name>

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.