Home » Server Options » Text & interMedia » BInd problem while loading to oracle
BInd problem while loading to oracle [message #76158] Thu, 09 December 2004 21:16 Go to next message
Selva
Messages: 15
Registered: June 2001
Junior Member
Art Metzer ,

here i stepped out my procedure

2.spool the datas to a csv file with 40 columns.some column may have 2000 data lenth.

3.load the csv to new table same column as the old table.

problems:

1.while loading the conventional path method i got this error information in log

Space allocated for bind array: 11352 bytes(1 rows)

Space allocated for memory besides bind array: 0 bytes

2.the column length of(2000) in data file . the log shows the column length of data file exceeds the column in the table.

so how two solve this issues,

can anybody please solve this problem?

Thanks in advance
Re: BInd problem while loading to oracle [message #76159 is a reply to message #76158] Fri, 10 December 2004 11:56 Go to previous messageGo to next message
bigger tables
Messages: 1
Registered: December 2004
Junior Member
Can you make the columns in the new table bigger to fit the unexpected size?
Re: BInd problem while loading to oracle [message #76177 is a reply to message #76159] Sun, 16 January 2005 19:18 Go to previous message
Selva
Messages: 15
Registered: June 2001
Junior Member
No, we should not change any column length,data or anything.that should be the exact copy of a old table.
Previous Topic: can i start off with ORACLE 10g by jus knowing oracle 8 .
Next Topic: How to extract datas from table to csv
Goto Forum:
  


Current Time: Thu Mar 28 18:37:52 CDT 2024