Re: Use one tablespace in two databases???

Hi Kenneth,

thanks for the advice. I've been experimenting a bit with the transportable tablespace and I wonder if it's possible to use the original datafile instead of copying it. Since I can mount the filesystem from the first server on the second one, that would save the time of making a copy and any changes would be available directly.

regards,
Bert Jan Meinders
Oracle DBA

Kenneth Koenraadt wrote in message news:<3d106dd2.2196137_at_news.capgemini.se>...
> 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
Received on Wed Jun 26 2002 - 07:36:23 CDT