Home » SQL & PL/SQL » SQL & PL/SQL » BULK insert (sql 2000)
BULK insert [message #356930] Mon, 03 November 2008 04:36 Go to next message
Messages: 93
Registered: October 2008
Location: Nepal

i am using a bulk insert to insert data from plain text file.

the records are terminated by !

when i use bulk insert i get that

Server: Msg 4832, Level 16, State 1, Line 1
Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.

What could be the possible reasons?

Re: BULK insert [message #356932 is a reply to message #356930] Mon, 03 November 2008 04:41 Go to previous messageGo to next message
Messages: 540
Registered: February 2008
Senior Member
what is the script file contents (loader)
Re: BULK insert [message #356933 is a reply to message #356930] Mon, 03 November 2008 04:43 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not an Oracle error message.
Investigate the program that executes the process.
Obviously it reaches the end of the file before it completes to process the preceding step. A missing '!'?

Previous Topic: date & calendar table
Next Topic: insert with condition
Goto Forum:

Current Time: Mon Jul 24 06:07:30 CDT 2017

Total time taken to generate the page: 0.19737 seconds