Oracle Database Creation

To create a table space : Create tablespace pdb_videos_pace datafile ' f:/oracle/app/oradata/orcl/pdb_videos_pace.dbf ' size 200M autoextend On next 5M maxsize 3000M;

Create a user and assign a default tablespace : create user Jsby identified by Jsby default tablespace pdb_videos_pace;

Give the user the appropriate permissions: grant update any table to Jsby;    grant select any table to Jsby ;    grant create any View to Jsby;    grant create any Sequence to Jsby;    grant create any Table to Jsby;    grant Delete any Table to Jsby;

Grant insert any table to Jsby; Grant connect to Jsby;

Oracle Database Creation