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