Re: create database fatal error
Date: Fri, 04 Jul 2008 21:47:19 +0100
Ana C. Dent wrote:
> We can only see what you post & what you post may not actually reflect
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
> 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