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.
Think.
Act..
Be proud...
and then find a dba who can answer your questions or guide you through stuff
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks