Oracle basics

Hello,

I have a quick. I can't seem to find a deffinative answer on this and I am sure that there are a number of other people who must also be suffering the same confusion.

Basically, I need some help understanding the structure of Oracle objects, both physical and logical.

People seem to refer to a database as a physical set of files that form a working data container and objects for Oracle. i.e. control files, redo logs & data files. I repeatedly see the fact that you can not see a tablespace at OS level as it is a logical structure, not physical. However, when I issue the following command:

create tablespace test datafile

      '/apps/oracle/data/test.dbf' size 200M

            default storage (

                  initial 8k

                  next 256k

                  pctincrease 0

                  minextents 1

            );

It does create a physical file which I can populate with tables, views etc...

At this point I have not issued the create database command and therefore wonder where it comes in to play and why I haven't had to issue the create database command. Is it to do with the default storage line ? Is this creating a database for me without my knowledge ?

If this is the case, then you would draw the conclusion that a tablespace is a logical division of a physical database. Is this correct ?

Any clarity on this would be appreciated. Received on Thu Sep 20 2001 - 09:15:41 CDT