Re: Newbie: Creating new database files

"Brian Peasland" <dba_at_nospam.peasland.net> wrote in message news:J8D6Jx.DFq_at_igsrsparc2.er.usgs.gov...
>> This sounds exactly like what I would like to achieve. Although I'm a
>> newbie to Oracle, I have spent many years using OpenVMS on Vaxes and
>> Alphas, specifically utilising the proprietary RMS record management
>> system using several legacy programming languages. I very much appreciate
>> the need to keep potentially conflicting applications apart for disk I/O
>> and security reasons. but my question still remains; how do I achieve
>> this under Oracle 10g Express Edition? (hey - it was free, OK?? :-) )
>
> You'll have to create seperate tablespace. Do this with the CREATE
> TABLESPACE command. Then move your application's tables and indexes to the
> tablespace with the ALTER TABLE MOVE and ALTER INDEX REBUILD commands.
>
>> I would also like to know if this is possible to do at run-time using SQL
>> exectued from a VB6 program.
>
> Once your application's objects are in their own tablespace, you do not
> have to do anything in your application code. Oracle will find the object
> when the code references it.
>
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown

Brian,

Many thanks, I'll give it a whirl.

Ade Received on Tue Nov 07 2006 - 09:56:38 CST