Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Undo tablespace error while creating a database
muzu1232005_at_gmail.com wrote:
> I got this error while creating the database. The Part from alert log
> file is given.
>
>
> Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
>
> ORA-00604: error occurred at recursive SQL level 1
>
> ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
> type
>
> Mon Jul 16 16:23:33 2007
>
> Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
>
> ORA-01501: CREATE DATABASE failed
>
> ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
> line 5792
>
> ORA-00604: error occurred at recursive SQL level 1
>
> ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
> type
>
> Error 1519 happened during db open, shutting down database
>
> USER: terminating instance due to error 1519
>
> Mon Jul 16 16:23:34 2007
>
> Instance terminated by USER, pid = 6080
>
> ORA-1092 signalled during: create database smalldb
>
> default temporary tablespace TEMPSMDB...
Where did "UNDOTSSMDB" come from? Certainly not from Oracle.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Jul 17 2007 - 10:49:59 CDT
![]() |
![]() |