Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PLS-00719: only widening of attribute 'string' constraints
is allowed



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

Post New Answer

More Oracle Errors Interview Questions

NNL-01040: Data streams opened by server: number

1 Answers  


ORA-27461: The value for attribute string is too large.

1 Answers  


NNO-00050: serious errors in configuration data, server cannot run

1 Answers  


ORA-25149: Columns of UROWID type may not be indexed

1 Answers  


ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint

1 Answers  


ORA-09826: SCLIN: cannot initialize atomic latch.

1 Answers  


ORA-13432: GeoRaster metadata blankCellValue error

1 Answers  


LPX-00250: invalid attribute declaration

1 Answers  


ORA-15126: component within ASM file name 'string' exceeds maximum length

1 Answers  


ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

1 Answers  


NCR-04012: NCRR: Invalid address descriptor

1 Answers  


LSX-00274: invalid padding in base64-encoded binary

1 Answers  


Categories