Home » SQL & PL/SQL » SQL & PL/SQL » how to exchange the non partiton table to partition table (Oracle 10g,Linux)
how to exchange the non partiton table to partition table [message #333285] Fri, 11 July 2008 02:39 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I need to create partition table from non partition table.
how to we create it?

scripts:

create table p_emp
(id number,
name varhcra2(23),
week_no number);

without droping p_emp table, how to exchange on nonpartiton table to partition table based on the week_no column for range partition table.

Thanks,
Michael



Re: how to exchange the non partiton table to partition table [message #333297 is a reply to message #333285] Fri, 11 July 2008 03:07 Go to previous message
Michel Cadot
Messages: 64435
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I need to create partition table from non partition table.
how to we create it?

Recreate it or use dbms_redefinition

Regards
Michel
Previous Topic: create table from remote db
Next Topic: comparing amounts
Goto Forum:
  


Current Time: Tue Feb 21 05:58:35 CST 2017

Total time taken to generate the page: 0.05216 seconds