This forum is currently locked. You can't register or post questions at this time. (read more)

Partitioning an unpartitioned table

All posts relating to Oracle database administration.

Moderator: Tim...

kaushik.nandy
Member
Posts: 43
Joined: Sun Oct 31, 2010 8:12 am

Partitioning an unpartitioned table

Postby kaushik.nandy » Mon Dec 24, 2012 7:19 am

hi,

I have an existing table that is not partitioned .
How do I create partition on the table without dropping the table.
The Table may or may not have constraints like primary key.
Assume that the table is empty.

Is there any way to partition the table using ALTER TABLE ADD PARTITION ....... syntax ??
I have using oracle 11g.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Partitioning an unpartitioned table

Postby Tim... » Mon Dec 24, 2012 10:22 am

Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 18 guests

cron