Oracle creates users and specifies default and default table spaces

Oracle creates users and specifies default and default table spaces

Create a temporary table space

Create temporary tablespace Bocodbtempdbs
Tempfile ' d:/oracle/oradata/bocodb/bocodata/bocodbtempdbs01.dbf '
Size 32m
Autoextend on
Next 32m MaxSize 2048m
Extent management Local;

Create a datasheet space
Create Tablespace Bocodbdbs
Logging
DataFile ' d:/oracle/oradata/bocodb/bocodata/bocodbdbs.dbf '
Size 32m
Autoextend on
Next 32m MaxSize 2048m
Extent management Local;

Create a user and specify a table space
Create user Bocodb identified by Bocodb
Default Tablespace Bocodbdbs
Temporary tablespace Bocodbtempdbs;

Granting permissions to Users

Grant Connect,resource to Bocodb;