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

LPX-00260: invalid xml:space attribute declaration

1 Answers  


SQL*Loader-00930: Error parsing insert statement for table string column string.

1 Answers  


ORA-16220: no failed transaction found

1 Answers  


ORA-01297: redo version mismatch between dictionary string and logfiles

1 Answers  


PROT-00012: Oracle Cluster Registry to be upgraded has an unsupported version

1 Answers  






RMAN-06184: duplicate object in backup specifier: string string

1 Answers  


ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables

1 Answers  


ORA-01932: ADMIN option not granted for role 'string'

1 Answers  


ORA-37114: OLAP API bootstrap error: (string)

1 Answers  


ORA-06742: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-15052: ASM file name 'string' is not in diskgroup "string"

1 Answers  


ORA-01122: database file string failed verification check

1 Answers  


Categories