-
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|