I have a table (A）， but don't create any index, then I can create partition for the table（A) by Toad？
Yes, and how easy or difficult this is depends on your Oracle version.
If you have Oracle version 12.2 or newer, then Oracle allows this, and Toad supports converting a non-partitioned table into a partitioned table (in the alter table window). In this case, it doesn't matter if you have created indexes or not.
If you have Oracle version 12.1 or older, the only way to accomplish this is to create a new table with partitions, then copy the data over, drop the old table, then rename the new table so it has the same name as the old one.
Oracle version 10 and newer has a package called dbms_redefinition that makes the rebuild process easier. Toad has a window that can use this package to help you do that. (main menu -> database -> optimize -> DBMS Redefinition Wizard)
If you have Oracle version 9 or older, the only way to do this to rebuild the table. In that case, you can right-click on the table in the Schema Browser and choose "Create Like", then create your new table (with a new name), then copy the data, rename the tables, recreate indexes, etc.
Thank you very much for your detailed reply, now my oracle version is 11.2.0.4, the only way to accomplish this is to create a new table with partitions, not only you tell me the solution but you also tell me the difference between the different vesions. thank you very much again.
1 Like