Re: shared tablespace

From: Paul Drake <bdbafh_at_gmail.com>
Date: Thu, 15 Mar 2007 17:53:33 -0400
Message-ID: <910046b40703151453t74c5115br4bcccbe220f760db@mail.gmail.com>

On 3/15/07, oracle sos <sosoracle_at_gmail.com> wrote:
> Good afternoon
>
> Does anyone has experience on shared tablespace? The situation is we have a
> common historical data and would like to share it between QA and DEV
> encivonment. QA and DEV are on the same server, and using ASM instance.
>
> I would like to get a procedure of how to perform this idea and appreciate
> your help and informaiton sharing.
>
>
>
> Thanks,
> Cindy

Cindy,

I think that what you are trying to actually accomplish is to access data that is being stored in one database from another database. The use of database links and synonyms is one way to provide this type of functionality, but there are a few caveats.

If cursor_sharing is set to anything other than exact, you'll likely hit a bug. If you're attempting distributed queries ... you may have performance problems. Selects now become distributed transactions ...

hope that helps.

Paul

-- 
Jay's Cycle Center club rides start March 14th at 6 pm.
Now includes 'C' level group.
http://www.jayscyclecenter.com
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 15 2007 - 16:53:33 CDT