Αποτελέσματα Αναζήτησης
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 Σεπ 2022 · A Database Link is an Oracle Database feature that allows an Oracle database to connect to a remote database, either Oracle or non-Oracle, and provide a interface for querying them both together. That means you can write one query that pulls data from both the local and remote database servers and joins them together (which is pretty useful).
23 Ιουν 2021 · You can query any table from Remote database using DBLink in Oracle database. To use dblink, I will explain Create Database Link ( DBlink ) & Privilege in Oracle in this post.
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.
In this tutorial, you have learned about the Oracle database link concept and how to use the Oracle CREATE DATABASE LINK to create a new database link to a remote Oracle Database server.
23 Φεβ 2023 · You need to look at the tnsnames.ora file on the server, figure out what MRP means there and then you can determine why that server (which may will be different then your mrp server) is not responding.
8 Αυγ 2019 · Create database link NAME connect to USERNAME identified by PASSWORD using 'SID'; Specify SHARED to use a single network connection to create a public database link that can be shared among multiple users. If you specify SHARED, you must also specify the dblink_authentication clause.
