How to Resolve ORA-65016: FILE_NAME_CONVERT
ORA-65016 and ORA-65180 Tried to clone a remote PDB with the same name and path and got ORA-65016 like this. SQL> create pluggable database ORCLPDB… Read More »How to Resolve ORA-65016: FILE_NAME_CONVERT
Database Link
How to Resolve ORA-17629 Oracle Error Message
ORA-17629 ORA-17627 ORA-12514 When we tried to clone a remote PDB via a DB link, we got ORA-17629 ORA-17627 and ORA-12514 in error stack like… Read More »How to Resolve ORA-17629 Oracle Error Message
How to Resolve ORA-17628 Error Message
ORA-17628: Oracle error 1031 returned by remote Oracle server In some situations, you might see errors like the following when cloning a remote pluggable database… Read More »How to Resolve ORA-17628 Error Message
How to Resolve ORA-01017 Error Message
ORA-01017: invalid username/password; logon denied ORA-01017 means that you either provided an incorrect pair of username and password, or mismatched authentication protocol, so the database… Read More »How to Resolve ORA-01017 Error Message
How to Resolve ORA-04063: view has errors
ORA-04063 ORA-04063 means the view that you want to grant to someone else has compile error, so the database cannot grant it to other users.… Read More »How to Resolve ORA-04063: view has errors
How to Migrate Data from 9i to 12c via DB Link
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 Migrate Data from 9i to 12c via DB Link
How to Resolve ORA-12899: value too large for column
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 Resolve ORA-12899: value too large for column
How to Use GLOBAL_NAMES for Database Links
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 »How to Use GLOBAL_NAMES for Database Links
DB Link, How and Why
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 »DB Link, How and Why
How to Resolve ORA-00942: table or view does not exist
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 »How to Resolve ORA-00942: table or view does not exist