Dataguard & ALTER TABLE MOVE tablespace

From: Stephen Andert <andert_at_gmail.com>
Date: Wed, 19 Apr 2006 18:38:47 -0700
Message-ID: <6d45e210604191838g6ebc8ba2x7a9d1b37f4e0b32a@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 19 2006 - 20:38:47 CDT