Dataguard & ALTER TABLE MOVE tablespace

  • From: "Stephen Andert" <andert@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 19 Apr 2006 18:38:47 -0700

Physical standby open in read only

When trying to move a table to a new tablespace in the source db, the
standby appears to not move the table to the new tablespace. Is this
expected behavior?

Since the db is in read-only mode, I obviously cannot move the table there.

I need to get objects to a new tablespace (long story, but old mount points
need to go away and this looks like the way to do this with least downtime
for most objects)

Any ideas?

Stephen Andert

Other related posts: