### SQL merge into cdbasesys_config t1 using select as CONFIG_ID as CONFIG_TYPE as APP_NAME

The error message "ORA-01031: insufficient privileges" indicates that the user executing the SQL statement does not have sufficient privileges to perform the operation. This could be due to the user not having the necessary permissions to modify or insert data into the specified table.

To resolve this issue, you will need to grant the necessary privileges to the user executing the SQL statement. You can do this by connecting to the database as a user with administrative privileges and executing the appropriate GRANT statement.

For example, if the user executing the SQL statement is called "user1" and needs the necessary privileges on the "cdbase.sys_config" table, you can grant the necessary privileges with the following statement:

GRANT INSERT, UPDATE ON cdbase.sys_config TO user1;

This will grant the user "user1" the privileges to insert and update data in the "cdbase.sys_config" table. Make sure to adjust the table name and the specific privileges as needed for your situation