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...