| Tablespace creation error [message #161952] |
Wed, 08 March 2006 00:35  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
I got the following error when i tried to create a tablespace as follows,
SQL> create tablespace temp1
2 datafile 'c:\oracle\oradata\newdb\new.dbf' size 250k temporary;
create tablespace temp1
*
ERROR at line 1:
ORA-12913: Cannot create dictionary managed tablespace
Can anyone explain me,
1) What is the reason for this error?
2) What i've to do to avoid this error?
Thanks,
Malru
|
|
|
|
| Re: Tablespace creation error [message #161964 is a reply to message #161952] |
Wed, 08 March 2006 01:02  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Check if your system tablespace is locally managed or dictionary managed.
You can't have a dictionary managed tablespace in case the system tablespace is locally managed.
--Girish
|
|
|
|
| Re: Tablespace creation error [message #161967 is a reply to message #161952] |
Wed, 08 March 2006 01:11 |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi Girish,
My SYSTEM tablespace is locally managed
I issued the following command to convert SYSTEM tablespace from locally managed to Dictionary managed,
SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM');
BEGIN DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM'); END;
*
ERROR at line 1:
ORA-03251: Cannot issue this command on SYSTEM tablespace
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1
But i got this error,
What i've to do to convert SYSTEM tablespace from locally managed to Dictionary managed?
|
|
|
|
|
|
|
|
| Re: Tablespace creation error [message #162138 is a reply to message #161952] |
Wed, 08 March 2006 23:18 |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi vijaychauhan,
I made all other tablespaces READONLY.
SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
DRSYS READ ONLY
INDX READ ONLY
TOOLS READ ONLY
USERS READ ONLY
XDB READ ONLY
8 rows selected.
SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM');
BEGIN DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM'); END;
*
ERROR at line 1:
ORA-03251: Cannot issue this command on SYSTEM tablespace
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1
Still it's giving the same error.What i've to do now?
|
|
|
|
| Re: Tablespace creation error [message #162158 is a reply to message #162138] |
Thu, 09 March 2006 00:42 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| gajini wrote on Thu, 09 March 2006 10:48 |
.
SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM');
BEGIN DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM'); END;
*
ERROR at line 1:
ORA-03251: Cannot issue this command on SYSTEM tablespace
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1[/b]
|
Why do you want to do it when Oracle doesn't allows it.
Long story short--- You can not do it.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
