> Hello,
>
> I am trying to bulk insert into Oracle using a dump file. Whenever the
> insert operation changes to another table, it freezes.
You're gonna have to post some INSERT commands for us to comment.
However, one possible tip...
I recently produced some insert files from Excel (custom VBA code
generator) and was feeding them quite happily into Borland's JDataStore
and Faircom's ctreeJavaServer.
When my client tried loading them into Oracle he found that the Oracle
interactive SQL utility interpreted & characters and so he had to
replace all & with \& (simple text search and replace).
Are you sure that it is the change of table causing the problem?
Another possibility is comment rows preceding the new tables - is there
just pure SQL in the files?
These are two things that tripped us up taking import files between
databses recently.

Signature
Andy Dent BSc MACS AACM http://www.oofile.com.au/
OOFILE - Database, Reports, Graphs, GUI for c++ on Mac, Unix & Windows
PP2MFC - PowerPlant->MFC portability