Home » RDBMS Server » Server Administration » locally managed tablespaces and dictionary managed tablespaces
locally managed tablespaces and dictionary managed tablespaces [message #53201] Mon, 02 September 2002 22:53 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
What is the difference between locally managed tablespaces and dictionary managed tablespaces?
How do they work in oracle 9i?

Report message to a moderator

Re: locally managed tablespaces and dictionary managed tablespaces [message #53205 is a reply to message #53201] Tue, 03 September 2002 06:45 Go to previous messageGo to next message
Michael
Messages: 61
Registered: October 1999
Member
Locally managed tbsps store the nessessary information about blocks and extents within an array in the tbsps itself, thus reducing the overhead when creating dictionary objects.

Dict mngd tbsps store all extent information in the dictionary tables in the SYSTEM tbsps.

Oracle recommends using locally mngd tbsps an all tbsps except SYSTEM.

Report message to a moderator

Re: locally managed tablespaces and dictionary managed tablespaces [message #53231 is a reply to message #53205] Thu, 05 September 2002 05:41 Go to previous message
Mike
Messages: 417
Registered: September 1998
Senior Member
In 9i Release 2 you can even use locally mngd tbs for the system tbs.
So I guess that sooner or later dict mngd tbs will disapear

Report message to a moderator

Previous Topic: Invalid database objects
Next Topic: 32 or 64-bit word size for Oracle on HP-UX
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 13 20:48:15 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.