Home » RDBMS Server » Server Utilities » Can we use SYSTIMESTAMP in SQL Loader
Can we use SYSTIMESTAMP in SQL Loader [message #157991] Tue, 07 February 2006 16:02 Go to next message
Ganeshbabu Venkat
Messages: 17
Registered: March 2001
Junior Member
Want to know how do we use SYSTIMESTAMP in SQL Loader. tried using the same way as sysdate its not working..
icon5.gif  Re: Can we use SYSTIMESTAMP in SQL Loader [message #237663 is a reply to message #157991] Tue, 15 May 2007 07:34 Go to previous messageGo to next message
rahulcvijay
Messages: 4
Registered: May 2007
Junior Member

hey even i wanted to know abt this..
Re: Can we use SYSTIMESTAMP in SQL Loader [message #237704 is a reply to message #237663] Tue, 15 May 2007 08:51 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have you double qouted systimestamp in the control file ?
i.e "systimestamp"

Re: Can we use SYSTIMESTAMP in SQL Loader [message #237712 is a reply to message #237704] Tue, 15 May 2007 09:03 Go to previous messageGo to next message
rahulcvijay
Messages: 4
Registered: May 2007
Junior Member

i tried using that

,ROW_ADDED_DATE_TIME "SYSTIMESTAMP"

but the records are getting rejected and in log file i am getting this error

Record 1: Rejected - Error on table AMIE_USER.DATA_SOURCE_BARTRAW, column ROW_ADDED_DATE_TIME.
ORA-01830: date format picture ends before converting entire input string
Re: Can we use SYSTIMESTAMP in SQL Loader [message #237714 is a reply to message #237712] Tue, 15 May 2007 09:05 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check this and see if it helps you http://www.orafaq.com/forum/t/58735/0/
Re: Can we use SYSTIMESTAMP in SQL Loader [message #237721 is a reply to message #237714] Tue, 15 May 2007 09:17 Go to previous messageGo to next message
rahulcvijay
Messages: 4
Registered: May 2007
Junior Member

i have posted a query there lets c..
it is

i have a similar issue.

i have a row ROW_ADDED_DATE_TIME of type TIMESTAMP(6) of a table which need to be populated with systimestamp.But when i specify ROW_ADDED_DATE_TIME "systimestamp" in the control file using double quotes as specified by a member i get an error in the log file

Record 1: Rejected - Error on table AMIE_USER.DATA_SOURCE_BARTRAW, column ROW_ADDED_DATE_TIME.
ORA-01830: date format picture ends before converting entire input string

Problem is slightly different from the above one because my datatype is timestamp and not varchar
Re: Can we use SYSTIMESTAMP in SQL Loader [message #301766 is a reply to message #237721] Thu, 21 February 2008 10:59 Go to previous message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
did it ever worked??
Previous Topic: SqlLoader Substring in Control File
Next Topic: how to get dump file size before exporting process ?
Goto Forum:
  


Current Time: Fri Dec 09 07:57:47 CST 2016

Total time taken to generate the page: 0.09085 seconds