Re: dbca ORACLE_BASE 9i and NT

"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

Have you tried

dbca -datafiledestination g:\anywhere

at the command prompt? It certainly works when you try and create a RAC database, and you want the datafiles created on the shared disk, not the regular private disk where ORACLE_BASE is likely to be found. Having just tried it for a non-RAC database, it didn't work... but that could be because it was just turned 6.45AM here, and I haven't woken up yet.

Worth experimenting with, anyway... "dbca -help" gives you all the command line arguments, of which datafiledestination is just one.

Regards
HJR Received on Sun Nov 23 2003 - 14:48:31 CST