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: 63911
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: Sun Oct 23 09:45:34 CDT 2016

Total time taken to generate the page: 0.14653 seconds