Database Tuning (MOSC)

MOSC Banner

I need to make move , alter table tablename move ,but I have almost 30 tables and each table contain

edited May 10, 2011 12:44AM in Database Tuning (MOSC) 11 commentsAnswered ✓
And each table has an indexes & constraints and as all you know these indexes will be invalidated

after the move ,this is consuming a huge time.

What is the better solution to make move for all the database with minumum time;keeping in mind my

database size is 200G ,and I have 7 tables contain long raw data types.

Thanks in advance. 

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