Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie: Creating new database files

Re: Newbie: Creating new database files

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 31 Oct 2006 09:05:39 -0800
Message-ID: <1162314338.182686@bubbleator.drizzle.com>


Ade wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1162225431.229544_at_bubbleator.drizzle.com...

>> Ade wrote:
>>> Hi,
>>>
>>> I'm a complete Newbie when it comes to Oracle so please excuse my simple 
>>> questions. I have installed Oracle 10g Express on my home system and so 
>>> far all works well. I can create tables etc, either programatically (VB6) 
>>> or using the GUI provided which I think is quite useable. I have a book 
>>> which I think is a very good reference (Hands on Oracle 10g Express foe 
>>> Windows published by Osbourne), but the only thing it doesn't explain is 
>>> how to create a fresh set of database files. Or is this the reason for 
>>> the Express edition?
>>>
>>> Any advice would be greatly appreciated.
>>>
>>> Ade
>> By "a fresh set of database files" what is it you are trying to 
>> accomplish?
>> -- 
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

>
> Hi,
>
> Ideally, as with Access previously, I would expect each application I write
> to have their own set of files which can be stored away from other
> applications. This was so easily done with Access (sorry if I'm swearing. by
> the way!!).
>
> With Oracle it appears that there is a central database area underneath the
> Oracle directory tree which will contain data for all applications using it.
> I can only see a separation between applications by the use of a
> username/password combination. Like I said, I'm a complete Newbie to Oracle,
> so please excuse me if I'm way off track.
>
> For some applications, I would like to keep data apart.
>
> In the good ole days on VMS (RDB 6 something) it was just a case of;
> SQL> create database filename 'mydb';
> which created the main database file and a snapshot file.
>
> With Oracle 10g Express, there doesn't appear to be an option available. I
> may have missed something though.
>
> Regards,
>
> Ade

MS Access is a toy: Oracle is an industrial strength RDBMS. Time to learn Oracle concepts and put away the old paradigm.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Oct 31 2006 - 11:05:39 CST

Original text of this message

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