Home » SQL & PL/SQL » SQL & PL/SQL » Insert into multiple blocks (Oracle 11.2.0.3)
Insert into multiple blocks [message #645036] Tue, 24 November 2015 03:55 Go to next message
pointers
Messages: 451
Registered: May 2008
Senior Member
Hi,

I would like to test something linked to clustering factor.
Could you please help me how to insert rows into a table such that each gets into different block.

Regards,
Pointers
Re: Insert into multiple blocks [message #645039 is a reply to message #645036] Tue, 24 November 2015 04:33 Go to previous message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just insert in parallel append mode.

Previous Topic: Selecting/Inserting Missing values
Next Topic: Decode expression help
Goto Forum:
  


Current Time: Tue Mar 19 04:24:05 CDT 2024