Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / General DB Topics / General DB Topics / August 2003

Tip: Looking for answers? Try searching our database.

Oracle: Bulk insert with multiple tables failing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Shakti Saran \(College of Computing\) - 17 Aug 2003 01:18 GMT
Hello,

I am trying to bulk insert into Oracle using a dump file. Whenever the
insert operation changes to another table, it freezes. Can someone please
help? I am an amateur at dba.

Thank you.

Shakti
--
"An idea is only as good as its most useful implementation to the
mankind" -- Shakti Saran
Andy Dent - 17 Aug 2003 17:41 GMT
> 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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.