RE: WebDB - how to access a different database

From: HAWKINS, JAMES W [FND/1000] <JAMES.W.HAWKINS_at_stl.Monsanto.com>
Date: Tue, 15 Aug 2000 08:55:09 -0500
Message-Id: <10590.114602@fatcity.com>

I do this quite a bit - you just need a database link in your MYDB to embed in your SQL that makes your reports, LOV's, etc. This should connect you to a userid on the NEWDB. Nothing needs to be installed on the remote database.

Jim

Jim Hawkins
Oracle Database Administration Team
Monsanto Company
800 North Lindbergh - G3ED
St. Louis, MO 63167

314.694.7592 - Office
314.308.6614 - Cellular
314.294.2623 - Pager
james.w.hawkins_at_monsanto.com

"Far better it is to dare mighty things, to win glorious triumphs, even though checkered by failure, than to take rank with those poor spirits who neither enjoy much nor suffer much, because they live in the gray twilight that knows neither victory nor defeat."

                                                   --Theodore Roosevelt

-----Original Message-----
From: Nguyen, Long [mailto:Long.Nguyen_at_its.csiro.au] Sent: Monday, August 14, 2000 11:54 PM
To: Multiple recipients of list ORACLE-L Subject: Webdb - how to access a different database

Hi,

I am learning Webdb. I have just installed webdb 2.2 on a solaris 2.6 server in a db called MYDB. So far I am working through the tutorial to become familiar with it. All db access so far has been on MYDB, where the webdb's PL/SQL packages are insatlled.

Question: From Webdb I want to access a different database aclled NEWDB on a different box, basically just login to that db under a userid and do a browse of db objects there . How would I configure webdb to do it? I think I need to create a DAD for that db, but do I need to load all the required packages on that NEWDB as well?

Thanks
Long

-- 
Author: Nguyen, Long
  INET: Long.Nguyen_at_its.csiro.au

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 Tue Aug 15 2000 - 08:55:09 CDT