Temporary datafile not getting dropped on physical standby
edited Feb 14, 2010 9:07PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Hi All,
We have a 4 node RAC primary database with a 2 node RAC physical standby, all running 10.2.0.2.
The temporary tablespace(bigfile) has grown on the primary, but only very little of it was used.
We wanted to reclaim the disk space by recreating the temp tablespace with a smaller size and reassigning it to the database.
We did the following, but the temporary datafile is not getting dropped on the physical standby
1) Created a new bigfile temporary tablespaces on primary with smaller size
2) Changed the database to use the new temp tablespace by issuing the following statement
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMPNEW"
We have a 4 node RAC primary database with a 2 node RAC physical standby, all running 10.2.0.2.
The temporary tablespace(bigfile) has grown on the primary, but only very little of it was used.
We wanted to reclaim the disk space by recreating the temp tablespace with a smaller size and reassigning it to the database.
We did the following, but the temporary datafile is not getting dropped on the physical standby
1) Created a new bigfile temporary tablespaces on primary with smaller size
2) Changed the database to use the new temp tablespace by issuing the following statement
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMPNEW"
0