Jeremy Wong wrote:
>
> Hi, I'm trying to create an Oracle 7.2 database running on WinNT and I
> cannot seem to do it when I try to put my configuration and datafiles
> anywhere outside the ORACLE_HOME directory. I tried to create a separate
> directory for my development environment to place my development database
> but I always get a database creation error when I run the script. It's OK
> when I do it in the ORANT directory (default ORACLE_HOME directory).
>
> The reason I need to do this is that ORACLE_HOME is in a partition with
> only a small amt of disk space, and the database I'm going to create could
> potentially be very huge. The only partition big enough is in another
> partition. I've given myself full administrative privileges on the OS and
> database levels.
>
> Has anyone ever encountered such a problem, or is this an Oracle for NT
> bug?
>
> Thanks,
> JeremyI have never encountered such a problem; but, if I did, I would just
create the data files in the existing oracle home directory, making them
small enough to fit (obviously). I then would go to server manager and
do the following:
1.open database nomount pfile...
2. alter database open
3. select * from v$datafile;
then alter each datafile with the following command:
4. alter database rename file <old name> to <new name with path as the
new path>
5. you can later enlarge each datafile via enterprise manager or with
other server manager commands.
Received on Fri Jan 03 1997 - 00:00:00 CST
