Create a tablespace in Oracle and create a user

Create a tablespace in Oracle and create a user

> //Create temporary tablespace Create temporary tablespace test_temp Tempfile 'e: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf' Size 32 m Autoextend on Next 32 m maxsize 2048 m Extent management local; // Create a data table space Create tablespace test_data Logging Datafile 'e: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_data01.dbf' Size 32 m Autoextend on Next 32 m maxsize 2048 m Extent management local; //Create a user and specify a tablespace Create user testserver_user identified by testserver_user Default tablespace test_data Temporary tablespace test_temp; // Grant permissions to users Grant connect, resource to testserver_user; // Log on to the user later. Any database objects created belong to the test_temp and test_data tablespaces. Therefore, you do not need to specify a tablespace for each object created.