ORA-04010: the number of values to CACHE must be greater than 1

Question Posted / guest

ORA-04010: the number of values to CACHE must be greater than 1..

Answer / guest

Cause: the value in the CACHE clause was one

Action: specify NOCACHE, or a value larger than one

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

LPX-00659: Output write failed.

NID-00002: Parse error: string

PCC-02364: Host struct and its indicator must have the same number of fields

ORA-02079: no new sessions may join a committing distributed transaction

ORA-28536: error in processing Heterogeneous Services initialization parameters

NNL-00524: Replaces a data item with another data item

ORA-38749: A media recovery has been started.

ORA-30563: outer join operator (+) not allowed in select-list

ORA-17505: ksfdrsz:string Failed to resize file to size string blocks

SQL-02154: Invalid or unset data type for host variable in ANSI Dynamic

RMAN-04024: trying to start the Oracle instance without parameter files ...

ORA-39031: invalid filter name string

For more Oracle Errors Interview Questions Click Here