Database Utilities (MOSC)

MOSC Banner

Moving large amount of data from source to the destination tables

edited Aug 4, 2015 11:17AM in Database Utilities (MOSC) 4 commentsAnswered

Hi

I'm in the process of moving large amount of data from the source table to some other destination table and delete the data after moving from the source .

The steps involved are

1. Insert one row at a time to the destination table through pl/sql code

2. Delete the the row from the source table.

1.What precautions to be taken while doing this activity on the production  .

2. How can I achive it without affecting the performance .

3.How can I reclaim the unused space with out affecting the performace.

Thanks

Sri


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