Database creation tablespace, temp table NULL, user, authorization

NOTE: Oracle version Oracle Database 11g Enterprise Edition release 11.2.0.1.0

Description: Create a temporary tablespace note that there are differences between the keyword and the CREATE TABLE space, similar statements

For explanation of creating statements please view: http://blog.chinaunix.net/uid-20802110-id-2105656.html

The statements listed are all tested and actual!

1. Create a table data space

Description: This version of the database creates tablespace execution logging times error, does not execute logging, default is also logging

Create Tablespace Cimp_space
DataFile ' d:\app\plm\oradata\orcl\cimp_space.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;

2. Create a temporary table space

Description: Temporary files (. dbf files) are placed in a random, Oradata folder that is typically placed in the Oracle installation directory

Create temporary tablespace data_temp
Tempfile ' D:\oracle\oradata\Oracle9i\user_temp.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;

3. Create user and set Tablespace

Create User Cimp
Identified by hp242g2
Default Tablespace cimp_space
Temporary tablespace cimp_temp;

4. Authorization

Grant CONNECT,RESOURCE,DBA to Cimp;

Database creation tablespace, temp table NULL, user, authorization