Re: points to be noted while creating a database,

From: Gerd Kock <info_at_gerd-kock.de>
Date: Fri, 12 Nov 1999 22:05:47 GMT
Message-ID: <382c8cc2.22401345@news.btx.dtag.de>

Hi Antony,

an Oracle database is no toy, you have learn something about the concept of Oracle:

physical structure:
- a tablespace consists of one or more data files

logical structure:

- data is always in an extent
- contigous extents are called a segment
- extents reside in an tablespace
- space for storing data (rows) in a table is allocated in extents
- at creation time of a tablespace you say what is the default extent

size for data allocated
- you can specify initial extent size, next extent size and optionally the percentage, how the extent size is increased every time an extent has to be allocated
- if you don't specify storage parameters for a table, the defaults from tablespace are used
- if no tablespace for table is specified, the default tablespace for the user creating the table is used
- at creation time of database you have to specify system tablespace, - later you can (and should) create some tablespaces for data, index, rollback segments ans os on.

there's much more, I don't know where to stop

Gerd Kock
info_at_no-spam.gerd-kock.de

On Fri, 12 Nov 1999 15:40:50 -0500, "PSINet News Service" <Antony.Amalraj_at_tpg.com> wrote:

>Hi every body,
>
> I am new to oracle 8i. I have to create a database with 200 tables,
>of Object-Model, Not a data-model. for development environement
>I am just wodering what are all the points to be noted while creating table
>space & table. could you please, summerise some plan with
>what could be the value for below parameters for transaction, temp,&
>master tables & tbspace.
>
> Initial extent, next extent, pctincrease, pctused,
>
>thanks in advance
>tony
>
>
Received on Fri Nov 12 1999 - 16:05:47 CST