ORA-30084: invalid data type for datetime primary with time
zone modifier



ORA-30084: invalid data type for datetime primary with time zone modifier..

Answer / guest

Cause: When a time zone modifier is specified, the data type
of datetime primary must be one of the following: TIME, TIME
WITH TIME ZONE, TIMESTAMP, TIMESTAMP WITH TIME ZONE.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02343: body of cursor must be a query expression

1 Answers  


ORA-27075: SSTMOFRC constant too large

1 Answers  


ORA-38612: FI item length cannot exceed half of one database block.

1 Answers  


TNS-00527: Protocol Adapter not loadable

1 Answers  


ORA-19507: failed to retrieve sequential file, handle="string", parms="string"

1 Answers  






DRG-10800: query failed: string string string

1 Answers  


ORA-01638: parameter string does not allow ORACLE version string to mount cluster database

1 Answers  


ORA-00443: background process "string" did not start

1 Answers  


ORA-07751: slemcr: malloc failure

1 Answers  


SQL*Loader-00605: Non-data dependent ORACLE error occurred -- load discontinued.

2 Answers  


ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)

1 Answers  


DRG-10826: no document with the specified textkey is found

1 Answers  


Categories