RE: Database link in the same DB

[Henry Poras]

Title: RE: Database link in the same DB

Lisa,

I can't remember the details off hand (need to dig up some old notes), but I believe I have done something like this to help deal with private database links on an import. Objects with private database links imbedded in them are a big mess on imports. I remember creating public links with the same link name using 'dummy', where dummy just pointed back to the same database. I still had some errors and recompiling to do, but it was easier than the alternative.

 

Henry

-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 5:53 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database link in the same DB

Why on earth would you want to do that??  I mean I'm bored and all but it hasn't occurred to me to do this!

Lisa Koivu
Oracle Database Monkey and Certified Couch Potato.
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----
From:   Aldi Barco [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, October 25, 2001 5:31 PM
To:     Multiple recipients of list ORACLE-L
Subject:        Database link in the same DB

Hi Listers,

Can we create and use database link within the same database ?
I have created one but still error when use it for select statement.
It's OK for database link to different database.

Thanks.

Aldi

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Aldi Barco
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).