Home » Developer & Programmer » Designer » TABLESPACES
TABLESPACES [message #90443] Thu, 25 September 2003 11:43 Go to next message
Upperm
Messages: 95
Registered: July 2003
Member
Hello folks,

I'm an oracle newbie. I'm using Win2k.

My question is about tablespaces!

1/ I really like to understand which option will be the best for a tablespace :
EXTENT MANAGEMENT LOCAL or EXTENT MANAGEMENT DICTIONARY ?

2/ I've created a tablespace like this:
CREATE TABLESPACE DATAS
DATAFILE 'C:ORADATAVENUSDATAS1.DBF' SIZE 1M REUSE;

What will happen when the "DATAS1.DBF" is filled ?

MERCI for your help :)
Re: TABLESPACES [message #90444 is a reply to message #90443] Thu, 25 September 2003 13:44 Go to previous messageGo to next message
Manish
Messages: 79
Registered: December 2000
Member
1) Dictionary managed tablespaces keep the metadata information of the tablespace in the dictionary ( dba_ views). Every time you need a new extent in the tablespace there is a recursive query to the dictionary this is a very expensive process.
2) Locally managed tablespaces keep the free extents informtion in the form of a bitmap at the header of the tablespace. So there is no recursive sql to the dictionary to find free extents. Locally managed tablespaces have uniform extent alLocation hence there is no fragmentation.
For mroe details refer documentation.

Once your datafile is full( if it si not set to autoextend on), of you try to write into it. you will get errors.

This is a nutshell for more details refer documetaion.
Manish
Re: TABLESPACES [message #90448 is a reply to message #90444] Fri, 26 September 2003 12:05 Go to previous message
Upperm
Messages: 95
Registered: July 2003
Member
Thanks a lot for your help MANISH.
Now things for me are more clarified.
though I still haven't found yet a location to get more documentation about tablespaces. I'll be thankful if you show me where to refer to it :)

Thank you once again.
Previous Topic: Circular relationships...
Next Topic: Re:TABLESPACES
Goto Forum:
  


Current Time: Tue Mar 19 03:43:08 CDT 2024