-
Error
When i tried to create the tablespace as,
SQL> create tablespace tbs01
2 datafile 'c:\oracle\oradata\newdb\new.dbf' size 250k
3 extent management dictionary;
create tablespace tbs01
*
ERROR at line 1:
ORA-12913: Cannot create dictionary managed tablespace
I got this error,
1) Why it's giving this error?
2) What is the solution for this error?
Anyone please answer for this as soon as possible.
-
1 - Because your sytem tablespace is locally managed.
2 - You need to recreate your database with system tablespace dictionary-managed
or
create your new tablespace locally managed.
-
and then find a dba who can answer your questions or guide you through stuff