ORA-00383 DEFAULT cache for blocksize string cannot be reduced to zero

Cause: User attempted to reduce DB_CACHE_SIZE to zero, or attempted to reduce DB_nK_CACHE_SIZE to zero while there were still online tablespaces with block size nK. Note that since the SYSTEM tablespace cannot be taken offline, it is always illegal to set DB_CACHE_SIZE to zero.

Action: Offline any tablespaces with the corresponding block size and then perform the operation again.

Solution doesn't works for you?
POST your error in our discussion panel below.
Our DBA team will be happy to help you :)

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments