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 to span into 2 tablespaces. If possible, please give me the script for the
Thanks in advance
No, a table is a table and a partitioned table is a partitioned table. I would suggest:
1. create a partitioned table with the same structure
2. exchange your table with a partition of the table
U can't partition an existing table which has no partitions at all. U can only alter already existing partitioned table.
Click Here to Expand Forum to Full Width