Hi Team,
Does anyone know if it is possible to use 'MOVE' on a table in a standby database?
There could be a requirement to 'defrag' a table in a migration database (clone, standby that will be activated as migration database).
Im still unsure of the merits of defragmentation but I guess thats another story..
One way to defrag a table segment is to MOVE it to the same tablespace;
ie
'alter table <table_name> move;'
Rather than import a 20tb database, Id rather use cloning to migrate the database initially as it is large, >20tb but there could be a requirement to defrag some tables along the way..
Can this be done online in a standby?
Can it be done if the standby database is in read only mode?
Is it possible at all or ONLY after the stdby has been activated?
Thanks for any reply.
jd