Categories
Oracle Rdb

Unload/Load Date/Time for Oracle

Store the VMS date as timestamp in oracle.

1) Use “delimited” text for unload
2) Before you invoke SQL*Loader ,define the NLS date (both on OS and
init*.ora) to match the date/timestamp format on unloaded file.
e.g If the date on unloaded file : 1998012113351752
VMS : $ DEFINE/SYSTEM NLS_TIMESTAMP_FORMAT
“YYYYMMDDHH24MISSFF”
Init*.ora : nls_timestamp_format=”YYYYMMDDHH24MISSFF”