Database Administration (MOSC)

MOSC Banner

ORA-01950 with Oracle 12c

edited Dec 23, 2015 10:00AM in Database Administration (MOSC) 6 commentsAnswered
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center