Re: manual creation

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 14 May 2004 22:42:06 +0200
Message-ID: <c83aoj$9r1$1@news5.tilbu1.nb.home.nl>

Howard J. Rogers wrote:

> d.j. wrote:
>

>> Sorry about that, the only part that I did not understand is the 
>> delete portion what are you deleting...
>>
>> <snip>
>> C:\newdb\admin>cd ..
>>
>> C:\newdb>del *.*
>> C:\newdb\*.*, Are you sure (Y/N)? y
>> C:\newdb> exit
>> <snip>

>
>
>
> Because the command is 'create something' not 'create something and if
> there's something of that name already there, please feel free to delete
> it and overwrite it'. Therefore, my second create database statement
> would have failed if I'd merely started it without first having cleared
> out the results of the first create database's failed attempt.
>
> You, of course, like every other 'create database' command I've seen
> included in books, bestrew your create database commands with 'reuse
> this' and 'reuse that'. I didn't, on the ground that I'd rather an old
> database didn't suddenly get turned into a pile of poo because I asked a
> new instance to do so, accidentally, without realising what I was doing.

Nice safety net, Howard!
Like the reasoning, too.
>
>

>> my paths are set up a little different  
>> c:\oracle\admin\sid\pfile\init.ora
>> c:\oracle\ora92\database\initsid.ora
>> c:\oracle\oradata\sid
>>
>> Your help is very much appreciated

>
>
> Well, just trying to get my name right would be a good start.
>
> Paths are irrelevant, so long as you are consistent in their use.
>

Which it is not. I have seen:

c:\oracle\admin\sid
C:\oracle\oradata\dew
C:\oracle\oradata\dec2g

The first would need to be c:\oracle\admin\dew, or dec2g; it's custom to replace sid with he actual name of the beast. In your case, dec2g, with which you started off the thread, or dew which it seems to be now.

So, decide what it should be, and stick to it. Helping you will get difficult when you start altering more than 1 thing at the time.

-- 

Regards,
Frank van Bortel

Received on Fri May 14 2004 - 15:42:06 CDT