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 best solutions below
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in DBLINK
- Managed ODP.NET Calls to PUBLIC Database Link tables cause TNS errors
- PostgreSQL different database connection slows down
- PostgreSQL 9.5: Hide password from dblink connection
- DBLink Optimized Insertions
- When does a database link connection is established?
- Is it possible to access a DB link through a DB link
- Bulk Binds over simple inserts in oracle 9i
- No records when using SELECT query on DBLINK in Oracle
- mysql and oracle issue using dblink
- Oracle 11g select from three databases using two dblinks
- mysql equivalent to oracle's dblink
- Securing Oracle distributed transactions against network failures
- How can I close Oracle DbLinks in JDBC with XA datasources and transactions to avoid ORA-02020 errors?
- Installing DBLink for Postgres 9
- Recovering jdbc connection after db link failure
Related Questions in DATABASE-LINK
- PL/SQL Block returns ORA-06553: PLS-114: identifier 'MyMSAccessFieldIsOver30CharsLong' too long when using a Remote NON-Oracle Database
- Oracle after update trigger creating public database link
- Call SQL Server functions via Oracle database link
- how do you spool from a stored procedure that is executed through a database link?
- create a foreign key to a column that exists on another server over a database link?
- Variable for Database Link Name
- Can you create dblink for the same database you are connected?
- Oracle: Cannot copy data from a max_string_size=extended to a max_string_size=standard database
- Creating an oracle databe link - ora-12154 error
- How does one cheaply validate the existence of a column in a table in another schema with Oracle?
- Problem when changing context (impersonation) and using a server link in SQL Server 2005
- ORA-24778: cannot open connections
- XA Datasource using Oracle DB links in Java EE Container managed transactions
- How to Import Google workspace data automatically to Big Query database?
- Database link between Oracle and Informix
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)
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?
It is possible, but you have to create the corresponding database links.