Today while creating the database manually for our development environment, I incurred following error.
When I checked my alter log It showed me as follows:
After that I checked parameter file which showed me value of undo tablespace as follows:
After this I change the name in my create database script same as above i.e. “UNDOTBS”. Once done the database was created without any error.
I hope this will help out somebody!
4 responses so far ↓
1 // Dec 20, 2008 at 12:21 am
Thank you very much! Saved me some time.
2 Soumendra Jena // Jan 18, 2009 at 11:14 am
Wow buddy,thats a great way to fix the error.
Im not able to find,how to create a database manually in Oracle 9i.
Can you plz throw some light ??
Thanks
3 Carlos Flores // Mar 7, 2009 at 5:43 am
Thanks!!!
It was succesfully!!
4 Deiaa Mohamed // Aug 12, 2009 at 2:50 pm
thank you , your comments help me also.
Leave a Comment