Question On Alter Table

Hi,

I have to break a given big table into 2 partitions. So I would like to know from you, if it is possible to partition the existing table into to 2 tablespaces. If possible, please give me the script for the
Alter table

Thanks in advance
Badrinath

Please read the above question as


Is it possible to partition the existing table spaning to 2 tablespaces using the alter table command?

I am using oracle 8.1.6
Badrinath

You can't place the data of a single table (unless it is partitioned table) in different tablespaces. But, it is possible to allocate extents for the same table in diffent datafiles of the same tablespace.

You can partition a table based on certain key column value.
And each partition can be placed into different tablespace.

You cannot do it directly, but you:

1: create a parition table with same logical as
your original table with one partition whose
partitioned key is larger than max(PK_ORIGINAL_TABLE)
2. alter table exchange partition with table
command to exchange with your original table
3. split the partition

Hope it helps!