-
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.
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
|