OraFAQ Forum: Server Administration » can't create dictionary managed tablespace

Home » RDBMS Server » Server Administration » can't create dictionary managed tablespace

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

can't create dictionary managed tablespace [message #126648]

Wed, 06 July 2005 01:44

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

I am running Oracle 9.2.0.1 on Windows XP, its a test database. I was just trying to create dictionary managed tablespace and got an error message.

SQL> create tablespace userdata datafile
2 '/u01/oradata/user1.dbf' size 50M
3 extent management dictionary
4 default storage ( initial 200K next 200K pctincrease 50);
create tablespace userdata datafile
*
ERROR at line 1:
ORA-12913: Cannot create dictionary managed tablespace

Does Oracle doesnt allows to create dictinary managed tablespace since this version onwards ? But i think it was there in previous releases of 9i.

Tarun

Report message to a moderator

Re: can't create dictionary managed tablespace [message #126652 is a reply to message #126648]

Wed, 06 July 2005 02:04

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Sorry for the path mentioned in the command, bt still it is not creating the tablespace.

SQL> create tablespace userdata datafile
2 'c:\user1.dbf' size 50M
3 extent management dictionary
4 default storage ( initial 200K next 200K pctincrease 50);
create tablespace userdata datafile
*
ERROR at line 1:
ORA-12913: Cannot create dictionary managed tablespace

Report message to a moderator

Re: can't create dictionary managed tablespace [message #126698 is a reply to message #126652]

Wed, 06 July 2005 04:19

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

When your system tablespace already locally managed, you cannot create a tablespace that is dictionary managed.

Report message to a moderator

Re: can't create dictionary managed tablespace [message #126705 is a reply to message #126698]

Wed, 06 July 2005 04:49

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Thanks
for the reply Mahesh

Report message to a moderator

Re: can't create dictionary managed tablespace [message #126732 is a reply to message #126648]

Wed, 06 July 2005 07:22

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

And why would you want to?

Report message to a moderator

Re: can't create dictionary managed tablespace [message #128950 is a reply to message #126648]

Thu, 21 July 2005 06:23

ankursharma
Messages: 1
Registered: July 2005
Location: Delhi

Junior Member

hi tarun,
i case your problem regarding not able to create dictionary managed tablespace has not been solved then just look at your system tablespace weather it is locally managed or dictionary. according to me it should be locally managed. once you switch your system tablespace as locally managed then you cannot create any dictionary managed tablespace in your database, and there is no way to switch your system tablespace back to local from dictionary managed once you have made it locally managed. It might be possible that you have not made the system tablespace locally managed but if you have created the database from DBCA i.e. database configuration asisstant then it automatically creates the system tablespace locally managed........ so don't panic.....

Ankur Sharma
SQL Star International

Report message to a moderator

Re: can't create dictionary managed tablespace [message #128955 is a reply to message #128950]

Thu, 21 July 2005 06:39

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Hi Ankur,

The issues was already resolved . Anyways, thanks for ur reply.

Regards,

Tarun

Report message to a moderator

Previous Topic:	Tablespace/Database fragmentation
Next Topic:	to check if database is up and running from command prompt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 11:46:55 CST 2025