PLS-00719: only widening of attribute 'string' constraints
is allowed
Answer / guest
Cause: Modification to the attribute did not widen its
constraints or attempted to change the type of the
attribute. For NUMBER type attributes, scale and precision
can be changed to allow increase in number of digits after
and before the decimal point. For VARCHAR2 and RAW type
attributes the size can be increased. Other type attributes
are not allowed to be modified. Change of type of attribute
is also not allowed.
Action: Change the constraint specification so as to widen
the existing constraints.To narrow the constraints or to
change the type of the attribute, you must drop the
attribute and add it with new constraints or new type. In
that case you must also take appropriate steps to preserve
your existing data based on the type (if you want to
preserve it).Typically this will involve backing up the data
and restoring it after the ALTER TYPE.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 0 No |
ORA-28134: object cannot have fine-grained access control policy
ORA-04068: existing state of packagesstringstringstring has been discarded
RMAN-06029: the controlfile may be included only in a datafile backup set
ORA-29936: NULL association is allowed only with a column or an index
LPX-00219: invalid digit '~c' in character reference
ORA-24391: invalid fetch operation
ORA-14520: Tablespace string block size [string] does not match existing object block size [string]
NNL-00530: quit|exit : exit the names control program
QSM-01130: Multi MV rewrite not allowed if at least one query block has no MVs
ORA-13217: invalid parameters supplied in ALTER INDEX statement
KUP-04065: error processing LOBFILE for field string
LSX-00153: invalid combination of default and fixed attributes