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 -> 1.Create new schema? 2. Databases on a different drive?

1.Create new schema? 2. Databases on a different drive?

From: <kvemuri_at_my-dejanews.com>
Date: Thu, 06 May 1999 18:49:51 GMT
Message-ID: <7gso8c$csn$1@nnrp1.deja.com>


Hi I am not a qualified DBA nor I have any database experience, but I am setting up a Oracle7 Workgroup Server(version 7.3...) for a inhouse databases (huge, scientific data). I have set up a new SID, changed the Tnsnames.ora file and renamed all the files under \\orant\databases\ to reflect the new SID, now I have a problem : how do i create a new Schema ? any script that I can use? and next question : oracle_home is on the 'C' drive and I have a drive 'D' in which I would like to load the databases how do i specify the drive when I create the database? Help is appreciated. Thanks kavita

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu May 06 1999 - 13:49:51 CDT

Original text of this message

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