When creating database link in oracle database error failed with ORA-02153: invalid VALUES password string?
meda Changed status to publish 06/04/2023
Use no quotes for the DBlink name, no quotes for the user name , double quotes for the password and single quotes for the net service name.
Example:
Example: CREATE DATABASE LINK LINK_TO_HRM CONNECT TO HRM_DBLINK IDENTIFIED BY "123456" USING '(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=10.2.2.2)(PORT=1522)) (CONNECT_DATA=(SID = HRM)) )'
Ezana Answered question 06/04/2023