Re: Oracle V7.3.1, read-only tablespaces, and query instances

In article <sxdjd.169.000B49FA_at_orca.alaska.edu> sxdjd_at_orca.alaska.edu (David J. DeWolfe) writes:
>From: sxdjd_at_orca.alaska.edu (David J. DeWolfe)
>Subject: Oracle V7.3.1, read-only tablespaces, and query instances
>Date: Tue, 6 Dec 1994 11:17:15
 

>Hello all;
 

>We're looking for ways to provide users with a query instance, which, if
>possible, shares data with our production instance, only in read-only mode.
>With version 7.1 it's possible to alter a tablespace to be read-only, but is
>it possible to share the data files between two instances? One with it in
>read-write mode and the other read-only? We've been doing it this way for
>years on our MVS platform, and we're looking for reasonable ways to provide
>the same functionality with Oracle running on DEC OSF/1.
>
>It looks like we could probably do it with data base links if we had Trusted
>Oracle (we do not), as the SQL reference states that you can mount remote
>databases as readonly *if* you have Trusted Oracle.

What are you trying to accomplish? What about a read only account for each user or a generic one everyone uses. Why do you want to do this with another instance?

>I'll welcome any and all suggestions, discussion etc regarding this topic,
>what our possible options are, what other sites are doing etc.
 

>Thanks in advance
 

>David DeWolfe
>Data Base Specialist
>U. of Alaska Computer Network (UACN)
>Fairbanks, AK 99775
><sxdjd_at_orca.alaska.edu>
  Received on Fri Dec 09 1994 - 12:59:03 CET