If you simply delete the control files, and then create the new database using the "reuse" option on all of the "create tablespace" commands you will be fine. This is all I do when a create database command goes bad. But then, I do not use dbca - I always create the database using scripts. -------------------------------------------------------- This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of murtuja khokhar Sent: Thursday, August 31, 2006 1:31 AM To: oracle-l@xxxxxxxxxxxxx Subject: delete database manually Hi I have installed Oracle 9i on solaris but it has some problem in the database creation. When I am trying to startup database it's giving me this error ORA-01079: ORACLE database was not properly created, operation aborted I have tried to delete database using dbca tool but its also giving some error so I want to drop previously created database manually. Can you send me all the steps for delete database manually? ________________________________ Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. <http://us.rd.yahoo.com/evt=42297/*http:/advision.webevents.yahoo.com/ma ilbeta>