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

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...