OraFAQ Forum: Server Administration » differences between local and dictionary mangaged tablespace

Home » RDBMS Server » Server Administration » differences between local and dictionary mangaged tablespace (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

differences between local and dictionary mangaged tablespace [message #632461]

Sun, 01 February 2015 05:29

m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman

Senior Member

Hi,

Can someone explain me what is locally managed tablespace and dictionary managed tables and why locally is preferred ahead of dictionary managed with some good examples.I searched google but could not find any satisfactory answer.Appreciate if someone can help me on this.

Report message to a moderator

[Message index]

		differences between local and dictionary mangaged tablespace By: m.abdulhaq on Sun, 01 February 2015 05:29
		Re: differences between local and dictionary mangaged tablespace By: Michel Cadot on Sun, 01 February 2015 06:31
		Re: differences between local and dictionary mangaged tablespace By: BlackSwan on Sun, 01 February 2015 07:16
		Re: differences between local and dictionary mangaged tablespace By: m.abdulhaq on Sun, 01 February 2015 11:37
		Re: differences between local and dictionary mangaged tablespace By: BlackSwan on Sun, 01 February 2015 12:07
		Re: differences between local and dictionary mangaged tablespace By: Michel Cadot on Sun, 01 February 2015 13:56
		Re: differences between local and dictionary mangaged tablespace By: m.abdulhaq on Sun, 01 February 2015 22:01

Previous Topic:	Shutdown immediate hangs with message "WARNING: aiowait timed out x times"
Next Topic:	While installing the Database, i am getting error "ORA-24324: service handle not initialized&qu

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:03:05 CDT 2024