INSTALLATION DOCUMENTS BY RAVI

Saturday, August 25, 2018

Altering user password in oracle analytics cloud database

ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database OACDEVPDB1

ORA-01918: user 'USER1' does not exist








Enable oracle script as below
Sql> alter session set “_ORACLE_SCRIPT”=true;









Disable oracle script:
Sql> alter session set “_ORACLE_SCRIPT”=false;






No comments:

Post a Comment

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...