Home » SQL & PL/SQL » SQL & PL/SQL » Vertical partitioning (oracle 11g )
Vertical partitioning [message #580002] Tue, 19 March 2013 01:37 Go to next message
mei tambunan
Messages: 37
Registered: February 2013
Location: Medan
Member
Hi,

Can you explain me steps to do vertical partitioning in oracle

thanks before
Re: Vertical partitioning [message #580003 is a reply to message #580002] Tue, 19 March 2013 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create the new tables with the desired columns and copy the data from the original table to the new tables using INSERT SELECT.

Regards
Michel
Re: Vertical partitioning [message #580004 is a reply to message #580003] Tue, 19 March 2013 01:53 Go to previous messageGo to next message
mei tambunan
Messages: 37
Registered: February 2013
Location: Medan
Member

is only steps to do vertical partitioning sir
how to copy the data?
please give me the query
thanks
Re: Vertical partitioning [message #580006 is a reply to message #580004] Tue, 19 March 2013 02:09 Go to previous message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
is only steps to do vertical partitioning sir


Yes.

Quote:
how to copy the data?

Quote:
copy the data from the original table to the new tables using INSERT SELECT.


Regards
Michel
Previous Topic: repeat_interval in oracle Schedule
Next Topic: PLS-00382: expression is of wrong type
Goto Forum:
  


Current Time: Sat Apr 19 05:13:59 CDT 2014

Total time taken to generate the page: 0.16692 seconds