Re: What's the first steps?

Hi,

on W98 you only can use Personal Oracle. I'm not sure, but I think a startetr database is always created which you can tune to a good value...

Look at http://www.hoffmann-kiel.de/stdinst.html

to do some basic tuning.

After that, you should create tablespaces for your data and a user, which will own all tables.

To create the tablespaces, connect as SYSTEM, pwd MANAGER with SQL-Plus, which will be installed during installation.

So use the commands

CREATE TABLESPACE TBSP1 DATAFILE 'C:\ORAWIN98\DATABASE\tbsp1.dbf' size 20M;

if you want to create indexes as well, it's good to have them on another disk

CREATE TABLESPACE TBSP_IND DATAFILE 'D:\ORAWIN98\DATABASE\tbsp_ind.dbf' size 20M;

After that, create a user

CREATE USER RENAUD IDENTIFIED BY RENAUD default tablespace tbsp1;

Then connect as RENAUD pwd RENAUD and create all the tables and indexes. If you create an index, do not forget to specify the tablespace.

Hope it helps a bit,

bye
Uli

> I would like to know, the basic steps to do between those two steps :
>
> 1. Download Oracle 8 for installation on my win98 machine.
> 2.
> 3.
> 4.
> ...
> ...
> N. Create a database
> ...
> ...
> N+M. Connect to the database and create table
>
> This is not for buisness, only for a school thing, so not to much
security,
> the only person who will be using it is me.
>
> So if anybody got time to respond or a good URL, please reply in this
> newsgroup, or I'd preffer if you could inform me at
> renaud_at_tr.cgocable.ca
> renaud.
Received on Fri Nov 19 1999 - 12:35:48 CST