Database Link

How to Resolve ORA-01017: invalid username/password; logon denied

by Ed Chen
January 18, 2020January 20, 2021

ORA-01017 ORA-01017 means that you either provided an incorrect username or password, so the database that you tried to connect denied you to logon. SQL>… Read More »

How to Resolve ORA-04063: view has errors

by Ed Chen
December 7, 2019January 20, 2021

ORA-04063 ORA-04063 means that the view you want to grant to someone else has compile error, so the database cannot grant it to other users.… Read More »

How to Migrate Data from 9i to 12c via DB Link

by Ed Chen
November 16, 2019March 26, 2020

Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »

How to Resolve ORA-12899: value too large for column

by Ed Chen
November 13, 2019November 13, 2019

ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. Let's… Read More »

How to Use GLOBAL_NAMES for Database Links

by Ed Chen
July 2, 2019November 29, 2019

GLOBAL_NAMES Normally, we turned off GLOBAL_NAMES to prevent additional check on remote database before connecting to it. This is because we know where we are… Read More »

DB Link, How and Why

by Ed Chen
March 30, 2019October 24, 2019

What is DB Link? A database link is a kind of schema object in a database that enables users to access and manipulate objects on… Read More »

How to Resolve ORA-00942: table or view does not exist

by Ed Chen
March 23, 2019January 20, 2021

ORA-00942 means that SQL parser saw no such table or view in your usable scope while parsing SQL statement. In other words, table or view… Read More »

Intermediary Database 11g - Workaround to ORA-03134

How to Resolve ORA-03134: Connections to this server version are no longer supported

by Ed Chen
February 17, 2019November 16, 2019

Background of ORA-03134 As I mentioned in How to Resolve ORA-28040: No matching authentication protocol. ORA-28040 is not difficult to be solved if you were… Read More »

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

by Ed Chen
February 14, 2019January 16, 2021
15 Comments

ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As a… Read More »

Can We Create Database Links for Another Schema?

by Ed Chen
July 27, 2018October 24, 2019

The answer is no. You can see the reason why we can't create database links for another user in this post. Prerequisites for Creating Database… Read More »