Re: HELP! Setting up Oracle 8i RDBMS

sag1rk_at_yahoo.com (Sagi) wrote in message news:<54d80104.0211280926.1724f195_at_posting.google.com>...
> backdoor <noway_at_out.com> wrote in message news:<mp6buu4ujpppdk3b58sumuh18sg3sjtob1_at_4ax.com>...
> > How would I set up an ORACLE 8i RDBMS (Standard Edition) on a Windows
> > 2000 Server?
> >
> > I want to define 4 logical extents or "instances" with just one
> > Database ( Production, Test, Pilot and Demo)
> >
> > Any help or links to reference material / books is appreciated.
> >
> > Thanks,
>
> Hi,
>
> I guess your load on DB would be small. If this is correct then what
> you can do is create 4 users one for each (Production, Test, Pilot and
> Demo).
>

> If you have installed the Oracle Software and Opted the option of
> creating the Starter Database then you should be having the Database
> Up and running.
>
> You can test by executing the below command at MS DOS prompt
>
> c:\> sqlplusw system/manager
>
> SQL\> SHOW USER
> System
>
> If you are connected and can see SQL\> prompt then it means you can
> play with it now.
>
> To create a user:
>
> CREATE USER <UserName> IDENTIFIED BY <SomePassword>
> DEFAULT TABLESPACE <TablespaceName>
> TEMPORARY TABLESPACE <TemporaryTableSpaceName>
>
> Example:
> SQL\> CREATER USER RK IDENTIFIED BY RK
> 2 DEFAULT TABLESPACE USERS
> 3 TEMPORARY TABLESPACE TEMP ;
>
> SQL\> GRANT Connect, resource to RK ;
>
> SQL\> CONNECT RK/RK
> Connected.....
>
>
> Hope this answers your query.
>
> Regards,
> RK

I assume that these are just for messing around or for a project. The easiest way is to use Database Administrator which is a GUI tool. You can set up your instances by giving the name of your database ( Production, Test, Pilot and Demo) and then accept the defaults. You should note that each of these will be approx 1Gb in size.

Alternatively, I believe in your case a better solution would be to create one database and have 4 users (Production, Test, Pilot and Demo). These would work in their own schemas and give you the effect you desire.

In both cases you really need to know omething about Oracle setup and management.

Hope this helps

Paddy Received on Sat Nov 30 2002 - 13:34:34 CET