| Partitioning [message #64182] |
Tue, 28 December 2004 03:17  |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Hi Experts,
Is it possible to partition an exisiting Table.
I am thinking of partitioning Large tables using List,Range and composite partitioning.
My Oracle version is Oracle 9.2.0.5.
Please tell me if this is possible and How.
Thanks in advance.
Milind.
|
|
|
|
| Re: Partitioning [message #64183 is a reply to message #64182] |
Tue, 28 December 2004 04:05  |
Frank Naude
Messages: 4593
Registered: April 1998
|
Senior Member |
|
|
Hi,
You need to recreate your tables with the partitioning syntax as described in the "SQL Reference" guide.
If you need to do it on-line (cannot afford the downtime), look at the DBMS_REDEFINITION package as described in the "PL/SQL Packages and Types Reference" guide.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
