Re: TableSpace And Database

In previous article, David Tang (vgchat_at_c031.aone.net.au) wrote:
[QUOTE]Hello all
[QUOTE] I am a newbie to Oracle database. I am running oracle 7.1 on a NT
[QUOTE]server. After reading through the manuals, I still haven't have and idea about
[QUOTE] creating a new database associted with a few tablespace. I know i can create
[QUOTE]a tablepspace and its data file. And i can also create a database and its data
[QUOTE]files. But i don't know how they are link together. Can someone out there give
[QUOTE]me a hand on this ? :>

       Tablespace is a logical structure whereas data file is a physical structure.

       In creating the tablespace, you will specify the data file you use with the size of the tablespace. For instance,

           create tablespace ts
           datafile 'xxx' size 100M ....

--

                                                               Best Regards,

                                                                 Lun Wing San
                                                                 ­Û  ¥Ã   ·s


Email address : sunny_at_hkpc.org 
Telephone     : (852)2758 5936 / (852)2788 5841