Re: Read Only Tablespaces - Question

You may have luck with ALTER SYSTEM SUSPEND and its counterpart ALTER SYSTEM RESUME. Don't know if it fits your situation exactly, though.

    -bruce

"buckeye714" <buckeye234NObuSPAM_at_zdnetmail.com.invalid> wrote in message news:0504ebb3.9763807f_at_usw-ex0106-045.remarq.com...
> I have a couple of databases, 8.0.5 running on Solaris. These
> databases use some read-only tablespaces. Each day, one of the
> read-only tablespaces is changed to read write and one table in
> the tablespace is updated. When this is done, it is necessary to
> make the tablespace read-only again and then back it up. My
> problem is that I can not make the tablespace read-only with
> active transactions in the database. So, is there a clean way to
> temporarily disable transactions so that I can switch the
> tablespace to read-only? Any help would be greatly appreciated.
>
> TIA,
> Patrick
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Tue Aug 15 2000 - 20:32:18 CDT