table partitioning doubt

From: zmaker <paolo.aliverti_at_gmail.com>
Date: Wed, 14 May 2008 01:12:43 -0700 (PDT)
Message-ID: <1cdd4a1a-646f-46a7-ab13-cd42d50ef00b@34g2000hsh.googlegroups.com>


Hi!
I have a simple/stupid question about partitioning.

I have created an empty partitioned (by range) table.

Table A partitioned on field 'CID'.
First partition with CID <= MAXVALUE,
second partition with CID <= 10000.

When i will load data in this table, the data will be placed in their right partition...

So... a record with CID=500 will be saved in the second partition, and a record with CID=99999 will be placed in the first partition.

It's right?

Thank you very much for any response!
Ciao!

PS: sorry 4 my beta-version-english!!! Received on Wed May 14 2008 - 03:12:43 CDT

Original text of this message