OraFAQ Forum: Server Administration » Partitioning a existing table

Home » RDBMS Server » Server Administration » Partitioning a existing table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Partitioning a existing table [message #64043]

Wed, 08 December 2004 22:24

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

I want to PARTITION an existing table(having 100,000,000 +) records, If i move out these records and truncate original and copy back these records it will take a long time.

Anybody has a better solution than this!!

-Brayan.

Report message to a moderator

Re: Partitioning a existing table [message #64047 is a reply to message #64043]

Wed, 08 December 2004 23:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

what kind of partition are you looking into?
http://www.devarticles.com/c/a/Oracle/Partitioning-in-Oracle/1/

Report message to a moderator

Re: Partitioning a existing table [message #64058 is a reply to message #64047]

Thu, 09 December 2004 19:08

Brayan
Messages: 315
Registered: June 2002

Senior Member

I'm looking for a LIST PARTITION.
I want to create partition on a existing table.

Regds,

Report message to a moderator

Re: Partitioning a existing table [message #64067 is a reply to message #64058]

Sun, 12 December 2004 06:45

Mike
Messages: 417
Registered: September 1998

Senior Member

which version of oracle are you using?

Report message to a moderator

Re: Partitioning a existing table [message #64068 is a reply to message #64067]

Sun, 12 December 2004 18:37

Brayan
Messages: 315
Registered: June 2002

Senior Member

I'm using Orace 10g (Linux)

Report message to a moderator

Previous Topic:	Oracle 8i Configuration Tools fail to install
Next Topic:	DBWR In Action

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 22:59:26 CST 2025