Re: Use one tablespace in two databases???

If you are just reading data you do not need to access the tablespace , you need to access the Instance ( PRD1) and its data. As the 'simple' example provided by Kenneth shows, a database link will allow you to read data from PRD1 and use it in PRD2

Kenneth Koenraadt wrote:

>On 19 Jun 2002 04:31:04 -0700, sigdock_at_hotmail.com (Sig Dock) wrote:
>
>>Hi all,
>>
>>is it possible to use one tablespace in two databases at the same
>>time?? Here is my situation:
>>
>>I've created a tablespace REPD in a databse PRD1, located on a Sun
>>Fire 280 server. I want to use the same tablespace from a second
>>database, PRD2, located on another server. The second server can mount
>>the filesystem from the first server in read-only mode which is
>>sufficient for my purposes. The second database will only launch
>>queries on the REPD-tablespace.
>>Is there any way to make the REPD-tablespace also a part of the PRD2
>>database without the use of Parallel Server? We are using Oracle
>>8.1.6.0, Solaris 8 and the datafiles are located on a EMC cabinet.
>>Both sun servers are connected with a Gigabit fibre cable.
>>Anyone with a good idea??
>>
>>t.i.a.
>>
>>Bert Jan Meinders
>>Oracle DBA
>
>Hi Bert,
>The simple one :
>1) Create a database link from PRD2 to PRD1. The tablespace will not
>be "a part of" PRD2 directly, but you can access all its segments from
>PRD2.
>
>The tricky one :
>2) Use export/import with the TRANSPORTABLE_TABLESPACE option. There
>are certain restrictions on this feature (i.e. tablespace must be
>self-contained) and the export/import only creates a snapshot of the
>tablespace from PRD1 in PRD2.
>
>- Kenneth Koenraadt

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Jun 19 2002 - 10:28:11 CDT