When we tried to change tablespace storage paramters in a DBCA created database, we may get the following error information because the storage settings for locally managed tablespaces cannot be altered.
ORA-25143: default storage clause is not compatible with allocation policy.
Or, if you want to create a tablespace dictionary managed, you might get this error information:
ORA-12913: [...]
Filed under: Q & A | Tagged: Database Creation, Space Management, Tablespace | Leave a Comment »