Discussion :

[nkongolo.m]

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]

[pifor]

Oui, il semble que c'est possible avec le package DBMS_REDEFINITION:

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.

Voir: http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2245