OraFAQ Forum: SQL & PL/SQL » Insert into multiple blocks

Home » SQL & PL/SQL » SQL & PL/SQL » Insert into multiple blocks (Oracle 11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insert into multiple blocks [message #645036]

Tue, 24 November 2015 03:55

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

Report message to a moderator

Re: Insert into multiple blocks [message #645039 is a reply to message #645036]

Tue, 24 November 2015 04:33

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just insert in parallel append mode.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 22 12:49:48 CDT 2026