Home » SQL & PL/SQL » SQL & PL/SQL » Partitioning an existing table (oracle 9i, windows 2003 server..)
Partitioning an existing table [message #322393] Fri, 23 May 2008 06:19 Go to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi ,
Anyone can suggest me a strategy to partition an already existing table with roughly 1.56 million rows..? I was asked to partition the table with two columns like period_id and job_code..Pls help me out....
Re: Partitioning an existing table [message #322396 is a reply to message #322393] Fri, 23 May 2008 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to drop and recreate the table or use dbms_redefinition package.

Regards
Michel
Re: Partitioning an existing table [message #322398 is a reply to message #322396] Fri, 23 May 2008 06:26 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi Michel,
thank you for an instant reply...Well im not familiar with dbms.redefinition can you please brief me about it?...im not strong in pl/sql..

thnx,
Arun.
Re: Partitioning an existing table [message #322401 is a reply to message #322398] Fri, 23 May 2008 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_REDEFINITION

Regards
Michel
Re: Partitioning an existing table [message #322403 is a reply to message #322401] Fri, 23 May 2008 06:41 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
thank you Michel..is it advisable to use the other method that you stated i.e., recreating table? I suppose i might lose the data..

Regards,
Arun.
Re: Partitioning an existing table [message #322406 is a reply to message #322403] Fri, 23 May 2008 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course you first export data, I thought it is obvious.
Maybe you have to also disable some referential constraints.

Regards
Michel
Re: Partitioning an existing table [message #322410 is a reply to message #322406] Fri, 23 May 2008 06:55 Go to previous message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Ok Michel, Thanx for the help....

Regards,
Arun
Previous Topic: Dynamic Generation of Trigger Code
Next Topic: Unreachable Code Error
Goto Forum:
  


Current Time: Sat Dec 10 20:15:10 CST 2016

Total time taken to generate the page: 0.07677 seconds