Question On Alter Table

[badrinathn]

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

[badrinathn]

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

[sln81]

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.

[tamilselvan]

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

[sysdba]

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!