ORA-01950 with Oracle 12c
alter session set container=PDBORCL; CREATE TABLESPACE company_data DATAFILE '/app/melocal/oradata/orcl/pdborcl/companyt_data.dbf' SIZE 250 M PERMANENT; CREATE TEMPORARY TABLESPACE company_temp TEMPFILE '/app/melocal/oradata/orcl/pdborcl/company_temp.dbf' SIZE 120 M ; GRANT CONNECT,RESOURCE,CREATE VIEW TO COMPANY IDENTIFIED BY <password> ; grant create any directory to company; ALTER USER COMPANY DEFAULT TABLESPACE company_data TEMPORARY TABLESPACE company_temp; QUIT
With the above create_user script I'm creating a user "COMPANY" in the pluggable db under 12c.
When I'm subsequently trying to create tables (using an OCI program which logs as company/password@pdborcl)
0