I have increased open_cursors from 200 to 1000 and still got ORA-01000:
maximum open cursors exceeded --> Current SQL statement for this session:
ROLLBACK TO FM_1.
Please help if you can. Thanks
Hen

-----Original Message-----
From: Vu Linh
[mailto:oracledba-ezmlmshield-x98830952.[Email address protected]
Sent: Wednesday, May 21, 2008 9:21 PM
To: LazyDBA Discussion
Subject: RE: ora-01460 when using sqlldr to load the text file to a
timestamp column

Hi DBA
I get error ORA-01460 when using sqlldr to load data from text file
To a column with timestamp data type.

How to fix it ? Thanks
This is my ctl file

LOAD DATA
CHARACTERSET WE8MSWIN1252
INFILE 'BO_PROMPT_MAP.TXT'
INTO TABLE TRAX_OWNER.BO_PROMPT_MAP
APPEND
FIELDS TERMINATED BY ','
(
AUDIT_REC_CREATE_DTS DATE 'MM/DD/YYYY HH24:MI:SS',
AUDIT_REC_CREATE_APPL_ID CHAR(20)
)
~

Record 1: Rejected - Error on table TRAX_OWNER.BO_PROMPT_MAP.
ORA-01460: unimplemented or unreasonable conversion requested


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page