OraFAQ Forum: Server Administration » Creating a Dictionary Managed Tablespace.

Home » RDBMS Server » Server Administration » Creating a Dictionary Managed Tablespace.

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

Creating a Dictionary Managed Tablespace. [message #196064]

Tue, 03 October 2006 23:35

sandy_in123
Messages: 6
Registered: September 2006

Junior Member

Hi,
how can i create a tablespace that is dictionary managed. i know that if SYSTEM tablespace is locally managed we can't create a tablespace that is dictionary managed. eventhough if there is this concept in Oracle9i then would be some way to create a tablespace that is dictionary maanaged.

Thanks,

Report message to a moderator

Re: Creating a Dictionary Managed Tablespace. [message #196072 is a reply to message #196064]

Wed, 04 October 2006 01:04

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Lookup "CREATE TABLESPACE" in your SQL Reference Guide.

Report message to a moderator

Re: Creating a Dictionary Managed Tablespace. [message #196196 is a reply to message #196064]

Wed, 04 October 2006 08:19

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I hate to be so curious, but questions like these make me wonder why in the world anyone would want to create a DMT? This is not rhetorical.

Report message to a moderator

Re: Creating a Dictionary Managed Tablespace. [message #196600 is a reply to message #196196]

Fri, 06 October 2006 02:32

bwetkstr
Messages: 114
Registered: August 2005

Senior Member

I was wondering the same .. why would you want to go back to DMT's ?

Report message to a moderator

Previous Topic:	Partition Index
Next Topic:	dba_jobs_running, sql navigator.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:31:59 CDT 2024