Re: create database fatal error

Ana C. Dent wrote:

> We can only see what you post & what you post may not actually reflect
> reality.

If you think there is other information that is relevant which I have not posted in any of my previous posts, please let me know.

To answer your question number 1, what I posted was the template script.

> 2) The SQL above contains "reuse undo tablespace" which it should to
> succeed on multiple retries; but it does NOT contain "reuse" for the
> other files. If it did not error out then I suspect multiple
> system01.dbf files exist. Who knows which is actually opened & being
> used.
>
> OK, you have a problem, but nobody here has enough credible data to get
> you much closer to a working database.

See my previous post which contains error log etc. It has previously been concluded that the system tablespace is too small.

Let me rephrase the question; how do I increase the size of the system tablespace? I thought the modifications I did to the CREATE DATABASE statement would do it, but apparently I was mistaken.

I have searched the web and I find very little concrete information about the tablespace size that will help me understand what I have done wrong. So in an attempt to enlist some concrete expert help, I turn to this list. So I dont have to sit down and read three oracle books just to figure out this simple question. ( I have already read three other books to get to where I am now, with this script, with very little relevant to my situation)

So, any help would be appreciated.

regards Received on Fri Jul 04 2008 - 15:47:19 CDT