I wish to create a new database but

[stevenriz]

I wish to create a new database but want the oradata to be created in a new /oradata filesystem I created specifically for the new db. Trouble is when I run dbassist, I don't get to choose where to put the oradata files. What do I do?
Thanks!
Steve
ps - since there is nothing in the default database, I might just wipe it out and do it all from scratch. I could use the practice anyways.

 

[alexhu]

Use a scripts - see Adminisrators Guide Chapter 2

or

CREATE DATABASE newtest
CONTROLFILE 'filespec'
LOGFILE
GROUP 1 ('diskb:log1.log', 'diskc:log1.log') SIZE 50K,
GROUP 2 ('diskb:log2.log', 'diskc:log2.log') SIZE 50K
MAXLOGFILES 5
MAXLOGHISTORY 100
DATAFILE 'diska:dbone.dat' SIZE 2M
MAXDATAFILES 10
MAXINSTANCES 2
ARCHIVELOG
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET JA16SJISFIXED
DATAFILE
'disk1:df1.dbf' AUTOEXTEND ON
'disk2:df2.dbf' AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

Alex

 

[jee]

If you want to preserve your data, you can follow these instructions that were posted by someone else in response to a similar query today:

shut the database down

copy the datafile to the correct destination
(repeat above step for each datafile)

startup the database - startup nomount

alter database rename file 'filespec' to 'filespec'
(repeat above step for each datafile)

alter database open

As far as using the Database Configuration Assistant - it does let you put the datafiles where you want them - at least under Windows and if you have specified "Custom" rather than "Typical". If I remember correctly, it suggests a location, but you can change it.