Database Administration (MOSC)

MOSC Banner

IMPDP - load data between to part tables - exchange part

edited Oct 7, 2015 3:42PM in Database Administration (MOSC) 2 commentsAnswered

Oracle DB: 11.2.0.4

Linux: 6

INFO.: We have 250 daily date RANGE partition tables as follows. These are huge partitions  - 2.5 to  4 GB  each.

               Table A has 90 partition loaded and 160 empty partitions.

               Table B has 160 partitions that I need to load into Table A

Question 1: is it possible to exchange partition between two same structure partition table from Table A to Table B.

               For example: Can we exchange partition P_20150901 from Table A to  partition P_20150901 with Table B?

Question 2:  can I import via impdp the remaining 160 partitions in Table A without corrupting existing 90 partitions from table B?  Note: I can import 30 days at at time.  is there a way to avoid archived logs for this operation only?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center