Αποτελέσματα Αναζήτησης
18 Μαρ 2010 · This will show you any database links set up on the database: select * from dba_db_links; You would then have to search for any queries or objects using the db link by doing a text search of them for the link syntax <tablename>@<dblink name>
14 Νοε 2011 · These views are helpful for working with DB links in Oracle: DBA_DB_LINKS - All DB links defined in the database; ALL_DB_LINKS - All DB links the current user has access to; USER_DB_LINKS - All DB links owned by current user; See more in Oracle documentation
Most commonly, a database link is used to connect to a user in a remote database, where the USING clause points to an entry in the database servers "tnsnames.ora" file. For local links, the special entry of 'local' is used. Basic Usage. Once a database link is created, for example the "scott_remote" link, remote objects can be referenced as ...
A good way around this is to create a view in SCHEMA_B that exposes the table you want to access through the database link. This will also give you good control over who is allowed to select from the database link, as you can control the access to the view. Do like this:
9 Μαρ 2006 · If you want to know whether any database links exist in data dictionary views, and where the database links connect to, you can get the information from DBA_DB_LINKS view. Just launch your SQL*Plus or Toad, or whatever convenient to you and query the dba_db_links table.
4 ημέρες πριν · We have a query which has to get a set of rows over the db link which has a CONTAINS predicate on a column of CLOB. E.g. There is a DB A and DB B with table T1( c1 varchar2(10),c2 clob) . I want to run a query from DB A using dblink on DB B to query T1 which has a CONTAINS predicate on c2 and based on the query the rows have to return c1 from t1.
14 Απρ 2011 · While database links (DB links) provide significant advantages for distributed data access and management, they also come with certain drawbacks and considerations. Here are some of the cons of using DB links in Oracle databases: Security Risks: DB links can potentially introduce security vulnerabilities, especially if they are not properly ...
