How can I import a partition from one table into another in Oracle?

Posted by DaUltimateTrooper on Stack Overflow See other posts from Stack Overflow or by DaUltimateTrooper
Published on 2010-03-23T15:28:56Z Indexed on 2010/03/23 15:33 UTC
Read the original article Hit count: 177

I would like to know if the following steps are possible and how fast this is:

  1. Create a partition named part1 in Table A
  2. Drop partition part1 in Table B
  3. Import the Table A partition part1 into Table B

Can you provide me with an example if it is possible indeed? Or any resources I can look at?

© Stack Overflow or respective owner

Related posts about oracle-partitioning

Related posts about partition