Re:RE: db link from oracle 8.1.7 to 8.0.5

Kimberly,

    I've found that describing a table at a remote database that has a public synonym on that remote instance does not work as we would expect. Try 'desc <owner>.<tablename>@<database link>'

Also beware of describing V7 objects in V8 and above. You may get a message that states that the remote database does not have the required services.

Dick Goulet

____________________Reply Separator____________________
Author: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date:       9/12/2001 8:40 AM

There is a bug in describe using db link on 8.1.7. At least going from 8.1.7 to 8.1.7 and I assume its an issue going to other versions as well.

-----Original Message-----
Sent: Wednesday, September 12, 2001 5:11 AM To: Multiple recipients of list ORACLE-L

Try doing a describe across that db link from 8i to 8.0.5...

Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Acting Head, System Admin & Operations
Bedford Institute of Oceanography
Fisheries and Oceans Canada

> -----Original Message-----
> From: nlzanen1_at_EY.NL [SMTP:nlzanen1_at_EY.NL]
> Sent: Wednesday, September 12, 2001 5:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: db link from oracle 8.1.7 to 8.0.5
>
>
> Hi
>
> That should be no problem.
> I just tried it.
> Connect to database 8.1.7.2.1 and created database link cc1 without
> username & password that connects to cc1 (8.0.5, take my word for it) and
> works fine
>
> ****************************************************************
>
>
> SQL*Plus: Release 8.1.6.0.0 - Production on Wed Sep 12 09:01:55 2001
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
> With the Partitioning option
> JServer Release 8.1.7.2.1 - Production
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Session altered.
>
> 09:01:58 37-HOMEBASE-JACK> drop database link cc1;
>
> Database link dropped.
>
> 09:02:14 37-HOMEBASE-JACK> CREATE DATABASE LINK cc1
> 09:02:24 2 USING 'cc1';
>
> Database link created.
>
> 09:02:26 37-HOMEBASE-JACK> SELECT * FROM v$database_at_cc1;
>
> DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS_TIME
> PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_T LOG_MO
> ---------- --------- ----------------- ----------------- -----------------
> ----------------------- ----------------- ---
> 728855776 CC1 01-feb-2000 09:49 1 01-feb-2000 09:49
> 0 NOARCHIVE
>
> 09:02:42 37-HOMEBASE-JACK>
>
> **************************************************************************
> *
>
>
> Jack
>
>
>
>
> Arslan Dar <arslandar_at_skm.org.pk>@fatcity.com on 11-09-2001 19:10:24
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
>
> hi list,
>
>
> i am trying to make a database link from oracle 8.1.7 to oracle 8.0.5,
> but its failing,
> giving message "DB LINK NOT ACTIVE"
> global_names parameter is false on both the database,
> the schema in which its being created exists in both the databases with
> same password and privillages, and i am using CONNECTED USER mode of
> database link,
>
>
> is that possible to create db link in such conditions,
> any suggestions,
>
>
> Thanks in Advance
>
>
> Arslan
>
>
>
>
>
>
>
> =====================================================================
> De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
> uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
> vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
> derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
> Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
> volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
> voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
> verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
> worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
> Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
> vriendelijk doch dringend het e-mailbericht te retourneren aan de
> verzender
> en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
> Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
> voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
> algemene voorwaarden worden u op verzoek kosteloos toegezonden.
> =====================================================================
> The information contained in this communication is confidential and is
> intended solely for the use of the individual or entity to whom it is
> addressed. You should not copy, disclose or distribute this communication
> without the authority of Ernst & Young. Ernst & Young is neither liable
> for
> the proper and complete transmission of the information contained in this
> communication nor for any delay in its receipt. Ernst & Young does not
> guarantee that the integrity of this communication has been maintained nor
> that the communication is free of viruses, interceptions or interference.
>
> If you are not the intended recipient of this communication please return
> the communication to the sender and delete and destroy all copies.
>
> In carrying out its engagements, Ernst & Young applies general terms and
> conditions, which contain a clause that limits its liability. A copy of
> these terms and conditions is available on request free of charge.
> =====================================================================
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: nlzanen1_at_EY.NL
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: kimberly.smith_at_gmd.fujitsu.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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: dgoulet_at_vicr.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).