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: 64132
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: Wed Dec 07 22:05:32 CST 2016

Total time taken to generate the page: 0.15508 seconds