Member Avatar for tony75

Hi
How can Iremove all object that Im created in oracle database.
I have 8 tables and I would like to remove all which commans should I use?

  • 3 Contributors
  • 7 Replies
  • 1K Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by tony75

Recommended Answers

All 7 Replies

Member Avatar for Ancient Dragon

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

Edited by Ancient Dragon
Member Avatar for tony75

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?

Member Avatar for Ancient Dragon

DROP DATABASE will delete them all and the database.

Member Avatar for tony75

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.
Member Avatar for Ancient Dragon

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>

Member Avatar for tony75

Wonderful..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.