Multiload and partitioned table

Tools
Enthusiast

Multiload and partitioned table

Can we update the partitioned tables using Multiload utility?

3 REPLIES
Enthusiast

Re: Multiload and partitioned table

You can't use multiload on a column partitioned table...

You can either use TPUMP or load into a non-column partitioned table and then do INSERT/SELECT into the target table.

Senior Apprentice

Re: Multiload and partitioned table

Hi Qaisar,

of course you can't MLoad column partitioned tables, but the OP didn't talk about CP tables specifically.

Otherwise MLoading into partitioned tables is possible when the PI plus the partitioning column(s) are used for access (=WHERE) and none of them are updated.

Dieter

Enthusiast

Re: Multiload and partitioned table

Hi Dieter,

You are right. My bad! :)