I know this is kind of weird but I would just like to know how this was being setup. There are two database and they are the same (one is mirror from the other). The first db is named "reportsdw" and the other one is "reportsdwx". I tried to "select * from dual@reportsdw" on reportsdw db and it worked, but when I did this "select * from dual@reportsdwx" on reportsdwx it is not working. Can anyone explain that?
Can you create dblink for the same database you are connected?
2.5k views Asked by mysticfalls At
1
There are 1 answers
Related Questions in ORACLE
- sqlplus myusername/mypassword@ORCL not working with Oracle on Docker
- Oracle setting up on k8s cluster using helm charts enterprise edition
- Oracle Managed Data Access Client can't work from IIS but work for local debug environment
- If composite indexing created - indexing is called?
- Oracle Http server ISNT-07551
- why here not creating table?
- Data migration from Oracle Database Clob to GCP Bucket
- SQL Alchemy custom type, forcing blob bind parameter
- How to send message to syslog agent in plsql
- Whatever the data available in previous record it should add to the new record
- I have an Oracle SQL query that is giving me a "ORA-00918: column ambiguously defined" error on a line that is a comment line
- 'ORA-12170: TNS:Connect timeout occurredORA-12170: TNS:Connect timeout occurred' ERROR while working on oracle with laravel
- Is their any way i can open parallel query tabs
- VSCode Libraries not showing for New Java Project
- I can't ssh to my instance, Connection refused
Related Questions in DBLINK
- ORA-28500 from dblink oracle UUID
- Migrating data from source data into new relation?
- PL/SQL dblink Timeout Issue During Data Copy from Remote Site
- Check history session run by DB Link oracle
- Count of number of rows using dblink in postgresql
- how do i pass a list of variable values to a SQL statement in a postgres dblink function?
- Select data from 2 Data Bases without DB Link
- No Host information in dba_db_links
- Create dblink connection string from variables in PostgesSQL
- DBLink to connect to remote RDS Postgresql
- POSTGRESQL: How to store dblink SELECT result to an ARRAY?
- create view for all tables from multiple databases
- Create DBLINK from oracle to SYBASE
- How can I force a trigger to connect to a remote database using a specific account?
- How we can select blob data from One server another server using dB link
Related Questions in DATABASE-LINK
- PL/SQL: ORA-00904: "ArticleWarehouseCode": Invalid Identifier
- How to drop table with dblink
- Retuning statement with dblink gives error
- Retrieving numbers in ranges via Oracle SQL
- MView from remote table over database link gets empty after recreation of table
- Can I create a database link from Oracle 18c to a JDBC data source with just the proper JAR file?
- Accessing table and column comments in Oracle for tables in SQL Server via databaselink
- ORA-01406 when copying data from one Oracle database to another with different Unicode
- Returning Multiple Values from Oracle Function over Database Link
- Local database docker to AWS database in VPN
- How to Import Google workspace data automatically to Big Query database?
- force Oracle to process recursive CTE on remote db site (perhaps using DRIVING_SITE hint)
- How To Prevent Database Links to Same Database in Oracle
- Oracle: Cannot copy data from a max_string_size=extended to a max_string_size=standard database
- XA Datasource using Oracle DB links in Java EE Container managed transactions
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
It is possible, but you have to create the corresponding database links.