Version imprimable
Est-il possible de partitionner une table non partitionnée auparavant?
La quantité des données a dépassé mes prévisions et les requêtes deviennent très lentes et poussent à des erreurs.
Je voudrais donc partitionner cette table.
Any help
[Sujet déplacé par Maximilian]
[ancien forum : MySQL]
Oui, il semble que c'est possible avec le package DBMS_REDEFINITION:
Voir: http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2245Citation:
Features of Online Table Redefinition
Online table redefinition enables you to:
*
Modify the storage parameters of a table or cluster
*
Move a table or cluster to a different tablespace in the same schema
Note:
If it is not important to keep a table available for DML when moving it to another tablespace, you can use the simpler ALTER TABLE MOVE command. See "Moving a Table to a New Segment or Tablespace".
*
Add, modify, or drop one or more columns in a table or cluster
*
Add or drop partitioning support (non-clustered tables only)
*
Change partition structure
*
Change physical properties of a single table partition, including moving it to a different tablespace in the same schema
*
Change physical properties of a materialized view log or an Oracle Streams Advanced Queueing queue table
*
Add support for parallel queries
*
Re-create a table or cluster to reduce fragmentation
Note:
In many cases, online segment shrink is an easier way to reduce fragmentation. See "Reclaiming Wasted Space".
*
Change the organization of a normal table (heap organized) to an index-organized table, or do the reverse.
*
Convert a relational table into a table with object columns, or do the reverse.
*
Convert an object table into a relational table or a table with object columns, or do the reverse.