Hi,
Database: 12cR1, 12.0.1.0, x64
System: Oracle Linux 6.4, x64
I installed a simple starter database during the installation of Oracle Database 12cR1 with the PDBORCL option selected (default) and would like to install the Oracle Example data, such as users HR schema, etc. according to http://docs.oracle.com/cd/E16655_01/server.121/e15979/installation.htm#I4367
@?/demo/schema/human_resources/hr_main.sql
CREATE USER hr IDENTIFIED BY hr
*
ERROR at line 1:
ORA-65096: invalid common user or role name
Perhaps the scripts were not designed for container and plug-able databases. I did the following:
alter pluggable database pdborcl open;
alter session set container=PDBORCL;
@?/demo/schema/human_resources/hr_main.sql
User altered.
Grant succeeded.
Grant succeeded.
Connected.
GRANT execute ON sys.dbms_stats TO hr
*
ERROR at line 1:
ORA-01917: user or role 'HR' does not exist
I could probably create a normal database, but I wonder if there is any other option without having to modify the setup scripts.
Thanks!