Oracle DBA, How To, Error, Cause and Action

ORA-14221: Dictionary managed tablespace cannot be used for this operation

ORA-14221: Dictionary managed tablespace cannot be used for this operation


Cause:


Attempted to create an index or add a LOB column in a dictionary managed tablespace to a table without a segment.



Action:


Specify a locally managed tablespace OR create segments for the table with the ALTER TABLE ALLOCATE EXTENT command.

No comments:

Post a Comment

Thanks for your comment.