Re: create database fatal error

From: gym dot scuba dot kennedy at gmail <kennedyii_at_verizon.net>
Date: Sun, 06 Jul 2008 16:29:38 GMT
Message-ID: <Sp6ck.304$P11.72@trndny06>

"Tommy Halsbrekk" <tommy_at_dummy.no> wrote in message news:g4qr2s$q9c$1_at_aioe.org...
> gym dot scuba dot kennedy at gmail wrote:
>
>> You know you can run dbca and have dbca create the scripts for you. Then
>> if you really want to build it yourself you can do it from that. You can
>> reverse engineer the scripts from the scripts that are produced.
>
> Yes I know, but I cant start over with this task every time I find there
> is a better way of doing it. But, thanks anyway.
>
> regards
>
> tommy

Now that really puzzles me. I would imagine you would only need to do it a couple of times. Once for each major release. You could even do a quick diff on each major release and find it doesn't change much. (yes, the contents of catproc etc. might change, but that isn't what you diff, just the outer process.)

I don't understand the business need to reverse engineer this. You can call dbca from a command line and have it create the scripts silently and even run them. I believe Oracle did it this way to make it easier for people installing (and less error prone, as you are finding out) I get the impression that you are in a big hurry. The irony is that if you went a little slower and did less you would achive a better result with less overall effort.
Jim Received on Sun Jul 06 2008 - 11:29:38 CDT

Original text of this message