Expand To Show Full Article
Oracle Error ORA-30572: AUTO segment space management not valid with DICTIONARY extent management - Developer Publish

Oracle Error ORA-30572: AUTO segment space management not valid with DICTIONARY extent management

Oracle Error Message

ORA-30572: AUTO segment space management not valid with DICTIONARY extent management

Reason for the Error

in CREATE TABLESPACE, the AUTO SEGMENT SPACE MANAGEMENT was used with a DICTIONARY extent management clause.

Solution

Either specify LOCAL extent management or remove the AUTO SEGMENT SPACE MANAGEMENT specification.