Re: HELP! Setting up Oracle 8i RDBMS

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 Received on Thu Nov 28 2002 - 18:26:28 CET