Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use the Oracle bulk loader with Warehouse on Unix to insert to an empty table ?

April 26, 2017bulk insert loader Oracle Table Unix warehouse

0

10 Posted

Can I use the Oracle bulk loader with Warehouse on Unix to insert to an empty table ?

1 Answer

0

10 Posted

When performance is a requirement, the Oracle SQL Loader (sqlldr) can be directed to read from a Unix FIFO that a Warehouse script is simultaneously populating. sqlldr blocks its input and then performs bulk inserts to the target table. Tip : Table indices can be rebuilt when the load has completed.