Can we Have a Column Partition on a MLOADED table?

Database
Enthusiast

Can we Have a Column Partition on a MLOADED table?

Hi Experts,

We created a partition on a DATE column which was not part of PI. This table was loaded by MLOAD and it got failed.After dropping the Partition it got suceeded. That way i concluded that MLOAD does not support Column Partition. Is that true? Also can you please let me know if MLOAD supports PPI?I know Mload supports NUSI. Please help me understand the limitations and the reason behind it .

Thanks,

Rakesh

Tags (2)
2 REPLIES
Enthusiast

Re: Can we Have a Column Partition on a MLOADED table?

Hi Rakesh,

As per my knowledge Fatload,Multiload is not suppported with the following:

  1. To load a table with USI, NUSI
  2. Column Partitioned table cant be loaded with Multiload
  3. Table with Standard Refrential Integrity defined
  4. Tables defined with Batch referential integrity constraint.
  5. Tables having an associated join index
Khurram
Enthusiast

Re: Can we Have a Column Partition on a MLOADED table?

Thanks Saeed