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?

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

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?

DROP DATABASE will delete them all and the database.

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.

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>

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.