ORA-00913 too many values
Cause: The SQL statement requires
two sets of values equal in number.
This error occurs when the second
set contains more items than the
first set. For example, the subquery
in a WHERE or HAVING clause may
return too many columns, or a VALUES
or SELECT clause may return more
columns than are listed in the
INSERT.
Action: Check the number of items in
each set and change the SQL
statement to make them equal.
You
might find some helpful information in
Oracle MOSC
regarding ORA-00913
regarding offline instantiation.
It is very common for users to encounter
ORA-00913 in this context in which
scripts that have been created during
offline instantiation fill the
materialized view, and the base table
fails along with the ORA-00913 error.
To
resolve case like these you should first
be sure to have
nls_numeric_characters='.,'
where DBMS_REPCAT_RGT was executed.
SQL> alter session set
nls_numeric_characters='.,';
-
For OEM, you may need to change the
language that has been set in
default in Windows locale using:
Start> Control Panel>Regional
Options
It is
important tat this behavior with
ORA-00913 is associated with bug
2227755, and has been fixed in some
versions.
Also,
on the
Oracle Technology Forums, a user is
reminded that in order to avoid
ORA-00913, you have to keep in mind that
"you
can update as many records as you want,
as many as your undo can support."
