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?
standard sql DROP TABLE <tablename>. You may have to drop indices first. DROP INDEX index_name
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?
DROP DATABASE will delete them all and the 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.
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>
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.