CREATE DATABASE LINK

How to Resolve ORA-01729: database link name expected

by Ed Chen
May 23, 2023May 26, 2023

ORA-01729 Tried to create a database link wich is able to connect to a remote database, but it failed with ORA-01729. Reserved Word SQL> create… Read More »

How to Resolve ORA-00924: missing BY keyword

by Ed Chen
May 4, 2023May 5, 2023

ORA-00924 ORA-00924 means that the reserved word BY is missing from the statement at the position where it points out in the error message. ORA-00924… Read More »

How to Resolve ORA-00946: missing TO keyword

by Ed Chen
November 30, 2022May 9, 2023

ORA-00946 There could be many cases that throw ORA-00946. Let's see some samples. Rename a Datafile Tried to rename a file of database but it… Read More »

JavaScript is not enabled. Please enable it and reload the page.