Dear Sir,
Can anyone tell me as to whether if it is possible to partition
an existing table(that has no partition in it) in a database and if so the syntax for the same.....
Thanks and Regards,
K.Diwakar
Printable View
Dear Sir,
Can anyone tell me as to whether if it is possible to partition
an existing table(that has no partition in it) in a database and if so the syntax for the same.....
Thanks and Regards,
K.Diwakar
Hi,
How to Partition an non-partitioned table?
SQL:
1. Create table dummy_t as select with the required partitions
2. Alter table EXCHANGE partition T with dummy_T
3. Drop table T
exp/imp:
Perform the following steps to partition an non-partitioned table:
1.Export the table to save the data.
2.Drop the table from the database.
3.Create the table again with partitions.
4.Import the table data.