OraFAQ Forum: Server Utilities » Can we use SYSTIMESTAMP in SQL Loader

Home » RDBMS Server » Server Utilities » Can we use SYSTIMESTAMP in SQL Loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can we use SYSTIMESTAMP in SQL Loader [message #157991]

Tue, 07 February 2006 16:02

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

Report message to a moderator

Re: Can we use SYSTIMESTAMP in SQL Loader [message #237663 is a reply to message #157991]

Tue, 15 May 2007 07:34

rahulcvijay
Messages: 4
Registered: May 2007

Junior Member

hey even i wanted to know abt this..

Report message to a moderator

Re: Can we use SYSTIMESTAMP in SQL Loader [message #237704 is a reply to message #237663]

Tue, 15 May 2007 08:51

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

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

Report message to a moderator

Re: Can we use SYSTIMESTAMP in SQL Loader [message #237712 is a reply to message #237704]

Tue, 15 May 2007 09:03

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

Report message to a moderator

Re: Can we use SYSTIMESTAMP in SQL Loader [message #237714 is a reply to message #237712]

Tue, 15 May 2007 09:05

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/

Report message to a moderator

Re: Can we use SYSTIMESTAMP in SQL Loader [message #237721 is a reply to message #237714]

Tue, 15 May 2007 09:17

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

Report message to a moderator

Re: Can we use SYSTIMESTAMP in SQL Loader [message #301766 is a reply to message #237721]

Thu, 21 February 2008 10:59

toshidas2000
Messages: 120
Registered: November 2005

Senior Member

did it ever worked??

Report message to a moderator

Previous Topic:	SqlLoader Substring in Control File
Next Topic:	how to get dump file size before exporting process ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 01:32:47 CDT 2024