Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbca ORACLE_BASE 9i and NT

Re: dbca ORACLE_BASE 9i and NT

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 23 Nov 2003 10:30:19 -0800
Message-ID: <1ac7c7b3.0311231030.295d2c30@posting.google.com>


"The Electric Frog" <Bouncedave2702_at_ameritech.net> wrote in message news:<bpqequ$1rbia4$1_at_ID-99427.news.uni-berlin.de>...
> Does anyone know how to "persuade" dbca under 9201 on an NT box to put it's
> datafiles in a different place than under ORACLE_BASE, I have a huge E: & G:
> drive yet I can't get dbca to want to put it's datafiles anywhere other
> than under ORACLE_BASE
>
> For the record, I've tried changing them in dba itsself but it the
> ORACLE_BASE screen seems to be read-only, and set'ing it prior to invoking
> dbca from the command prompt has little effect either, I even modified the
> dbca script to include -DORACLE_BASE=E:\Oracle to no avail

  1. save the create scripts to the filesystem and edit them prior to executing them.
  2. edit them in the dbca prior to saving it.
  3. set db_file_create_dest in the init.ora (provided that you create the db with an init.ora) and don't specify a path.

Pd Received on Sun Nov 23 2003 - 12:30:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US