Home » RDBMS Server » Server Administration » Bulk Insert.
Bulk Insert. [message #373161] Fri, 30 March 2001 09:40
Sanjay J
Messages: 1
Registered: March 2001
Junior Member
Hello,

I have Oracle8i running on Unix platform. There are around 4million records spread in 4-5 major tables .. The SELECT statement to extract the active records from these 4-5 tables runs well and has a good performance. The SELECT statement produces around 3million records .. now these 3million records have to be inserted into a table. I have tried inserting DIRECT-LOAD method ..but the performance isn't good. Please can anyone suggest a alternate method.

Thanks in Advance
Sanjay

Report message to a moderator

Previous Topic: COPY command failure, ORA : 01043 user side memory corruption [string], [string], [string], [string]
Next Topic: inserting diacritics
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 05:38:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.