Oracle-L: RE: privileges and synonyms and dblinks

From: Srinivas <zirraffeee_at_yahoo.com>
Date: Wed, 26 Jun 2002 12:49:41 -0800
Message-ID: <F001.0048953A.20020626124941@fatcity.com>

Hi,
Can someone please explain what is happening in this case.

I created link lnkAB from instA to instB, it is a private db link. with username and password in the link.

And then I created a synonym syntableX
(not public) on the tableX_at_lnkAB.world.

Now I tried desc syntableX at my instanceA, you wont believe the process hung forever. I couldnt even kill the the session from system.

I tried created tableXdest as select * from synTableX
(process frozen). Couldnt kill it.

I tried created tableXdest as select * from tableX_at_lnkAB.World (process frozen). Couldnt kill it.

I found on metalink
create table tableXdest UNRECOVERABLE as select * from synTableX. Worked fine. No problems.

to do a Desc synTableX I created a view "create view tview as select * from synTableX". Do Desc tview. Works just fine.

I couldnt understand what was happening in the above scenario. Could someone please explain. Using 8.1.7.on unix

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Srinivas
  INET: zirraffeee_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Jun 26 2002 - 15:49:41 CDT