Create local users in #Oracle 12c

One of the most annoying things is when some vendor decides that it is a good idea to change some very basic and long time existing basic behaviour.

In the new Oracle 12c you are no longer able to create local users the old way as sys:

CREATE USER my_app IDENTIFIED BY "pass";

If you try to execute the above the result is:

ORA-65096: invalid common user or role name

Now because of the new improved Oracle all this local users have to be prefixed by C##. But this creates a load of other problems and I do not want to brush through all the legacy SQL scripts one by one.

There is an undocumented fix for this. Enable the old way:

alter session set "_oracle_script"=true;