Αποτελέσματα Αναζήτησης
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:
2 Δεκ 2013 · In Oracle 11G I can easily invoke: SELECT * FROM TABLE@DB_LINK_NAME; But how invoke SELECT over DB_LINK that is on another DB_LINK? Something like this: SELECT * FROM TABLE@REMOTE_DB_LINK_NAME@
1 ημέρα πριν · There are 100 different cases where, as a database developer, I need to know where a column is used. I know there are ways you can find certain things, like in SYS.ALL_DEPENDENCIES, or searching other tables where COLUMN_NAME = 'OWNER', or looking in USER_SOURCE, etc. Some are helpful, others just return a lot of noise.
28 Αυγ 2021 · A database link is to allow one database to act as a client to another, and it is accessed by appending the name of the db link to the name of the table in the remote database: SELECT * FROM REMOTE_TABLE@LINK_NAME;
Use the query_table_expression clause to identify a subquery block, table, view, materialized view, analytic view, hierarchy, partition, or subpartition, or to specify a subquery that identifies the objects.
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. For example:
Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system.
