OraFAQ Forum: Server Administration » error while creating Dictionary managed Tablespace

Home » RDBMS Server » Server Administration » error while creating Dictionary managed Tablespace

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

error while creating Dictionary managed Tablespace [message #174051]

Thu, 25 May 2006 14:11

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

I want to create a Dictionary managed tablespace when i try fire the statement

create tablespace test_tbs datafile 'd:\oracle\oradata\test_tbs.dbf' size 100m
EXTENT MANAGEMENT DICTIONARY;

I am getting error
CANNOT CREATE DICTIONARY MANAGED TABLESPACE

why?

I tried

create tablespace test_tbs datafile 'd:\oracle\oradata\test_tbs.dbf' size 100m
EXTENT MANAGEMENT DICTIONARY
default storage(Initial 1m next 1m pctincrease 0);
still same
can anybody help.

thanks in advance

Report message to a moderator

Re: error while creating Dictionary managed Tablespace [message #174054 is a reply to message #174051]

Thu, 25 May 2006 14:22

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Is your SYSTEM tablespace DICTIONARY managed?

Report message to a moderator

Re: error while creating Dictionary managed Tablespace [message #174070 is a reply to message #174051]

Thu, 25 May 2006 15:01

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Yes.

Report message to a moderator

Re: error while creating Dictionary managed Tablespace [message #174468 is a reply to message #174070]

Mon, 29 May 2006 05:33

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Can you please provide output of this query:

select tablespace_name,extent_management
from dba_tablespaces;

Thanks
-Girish

Report message to a moderator

Re: error while creating Dictionary managed Tablespace [message #174807 is a reply to message #174051]

Tue, 30 May 2006 11:42

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Cool

I am sorry
all my tablespaces including SYSTEM are locally managed .

thanx

Report message to a moderator

Previous Topic:	Windows service
Next Topic:	Convert Excel files into Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:33:44 CDT 2024