Re: Location of data files on db creation

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 31 Jan 2003 06:56:22 +1100
Message-ID: <8jf_9.36866$jM5.93709@newsfeeds.bigpond.com>

Yes there is. Instead of running the database creation assistant from the menus (which you would have if this was Windows) you do what you do anyway in Unix, which is run the thing by invoking it from the command line. And at that point, you can supply an over-ride switch that sets a new default location.

For example:

$dbca -datafiledestination s:\oradata

...and when you get to the last page of the wizard, you'll see that all the data file locations are set to s:\oradata for you.

Regards
HJR "Mike Cutts" <mike.cutts_at_lineone.net> wrote in message news:8854ce2a.0301300525.6e34cf68_at_posting.google.com...
> Is there an easy way of telling Oracle to put all the data files in a
> different location when the database is created. At the moment, I am
> having to go through the custom installation and altering the path
> manually for the system files, tools files, indexes etc.
>
> Thanks,
>
> Mike.
Received on Thu Jan 30 2003 - 13:56:22 CST