RE: Basic Question

[Sinardy Xing]

Hi Santosh,

 

Tablespace is logical storage, datafile is physical storage (OS file).

Tablespace must consists of at least 1 datafile.

 

Example

 

Create tablespace my_tablespace

datafile 'my_tablespace's_datafile1'

 

 

NB: Storage is storing your database objects

 

Sinardy

-----Original Message-----
From: Santosh Varma [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2002 14:58
To: Multiple recipients of list ORACLE-L
Subject: Basic Question

Could any body tell me the different between DataFiles and TableSpaces ? Is it that Datafiles are the tables in a Database and Tablespaces are the spaces allocated for each table with Datafiles in that ???

Thanks and regards,

Santosh