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



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

Answer / guest

Cause: User attempted to reduce db_cache_size to zero, or
attempted to to reduce db_<n>K_cache_size to zero while
there were still online tablespaces with blocksize <n>K.
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
blocksize and then perform the operation again.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13340: a point geometry has more than one coordinate

1 Answers  


PLS-00439: A LIMIT clause must be used within a BULK FETCH

1 Answers  


AUD-00807: SpeechContains: index of indextype ORDSpeechIndex is required

1 Answers  


ORA-03221: Temporary tablespaces and temporary segments must have standard block size

1 Answers  


ORA-31038: Invalid string value: "string"

1 Answers  


ORA-03251: Cannot issue this command on SYSTEM tablespace

1 Answers  


ORA-02218: invalid INITIAL storage option value

1 Answers  


RMAN-08107: channel string: block restore complete

1 Answers  


ORA-28047: database is not a member of any enterprise domain in OID

1 Answers  


ORA-27508: IPC error sending a message

1 Answers  


RMAN-06429: %s database is not compatible with this version of RMAN

1 Answers  


ORA-02850: File is closed

1 Answers  


Categories