ORA-00383: DEFAULT cache for blocksize string cannot be
reduced to zero
- 1 Answers
- 2899 Views
- I also Faced
- E-Mail Answers
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 |
PCB-00316: SQL FORMS statements are Oracle extensions
TNS-01151: Missing listener name, string, in LISTENER.ORA
ORA-23415: materialized view log for "string"."string" does not record the primary key
QSM-00768: the search condition is invalid for the requested operation
SQL-01075: you are currently logged on
DRG-12503: error while creating or dropping stoplist
ORA-33334: (DSSEXIST04) Analytic workspace string is not attached.
ORA-01675: max_commit_propagation_delay inconsistent with other instances
ORA-24500: invalid UTF16 mode
NPL-00302: ASN.1 type tag is greater than maximum of 16383
O2U-00205: None of the characters in a type name were legal identifier characters
ORA-25954: missing primary key or unique constraint on dimension
Oracle Errors 
