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
9.2.0.5
AIX

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: