Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql*loader using db2 exported file

sql*loader using db2 exported file

From: <raju_pillai_at_yahoo.com>
Date: Tue, 19 Oct 1999 11:51:23 GMT
Message-ID: <7uhlvo$5ht$1@nnrp1.deja.com> 





Folks, I am trying to load a db2 exported file into Oracle database.
I am having trouble with loading a timestamp field into a data field in
oracle.  It looks like that Oracle does'nt understand the timestamp
field.  I treid giving date(26) "yyyy-mm-dd-hh-mm-ss-tttttt" in the
control file and still it does'nt like it.



How do it load a timestamp field into oracle date field ?  Please help



Thanks in advance



Raju




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Tue Oct 19 1999 - 06:51:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US