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...


ORA-14120: incompletely specified partition bound for a DATE
column



ORA-14120: incompletely specified partition bound for a DATE column..

Answer / guest

Cause: An attempt was made to use a date expression whose
format does not fully (i.e. day, month, and year (including
century)) specify a date as a partition bound for a DATE
column. The format may have been specified explicitly (using
TO_DATE() function) or implicitly (NLS_DATE_FORMAT).

Action: Ensure that date format used in a partition bound
for a DATE column supports complete specification of a date
(i.e. day, month, and year (including century)). If
NLS_DATE_FORMAT does not support complete (i.e. including
the century) specification of the year, use TO_DATE() (e.g.
TO_DATE('01-01-1999', 'MM-DD-YYYY') to fully express the
desired date.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13403: invalid rasterDataTable specification

1 Answers  


ORA-33008: (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.

1 Answers  


LFI-01501: tmpnam() fails to generate temporary file name.

1 Answers  


ORA-36904: (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.

1 Answers  


RMAN-10028: network error number-number occurred during remote RPC

1 Answers  


ORA-00964: table name not in FROM list

1 Answers  


NNO-00625: overriding auto-refresh of name "string", type "string", refresh in number seconds

1 Answers  


RMAN-06063: DBID is not found in the recovery catalog

1 Answers  


ORA-06743: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-00392: log string of thread string is being cleared, operation not allowed

1 Answers  


ORA-06443: ssvpstev: Incorrect parameter passed to function call

1 Answers  


ORA-36970: (XSRELTBL12) workspace object must be a self-relation.

1 Answers  


Categories