Oracle CREATE TABLE space detailed introduction _oracle

Note the point:
1. If open in Pl/sql and other tools, directly modify the following code [Italic bold section] to perform
2. To ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\" is the path you want to save the file exists
/* is divided into four steps * *
/* 1th step: Create temporary table space/*

Copy Code code as follows:

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

/* 2nd step: Create a datasheet space/*

Copy Code code as follows:

Create Tablespace User_data
Logging
DataFile ' D:\oracle\oradata\Oracle9i\user_data.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local;

/* 3rd step: Create user and specify Tablespace/

Copy Code code as follows:

Create user username identified by password
Default Tablespace user_data
Temporary tablespace user_temp;

/* 4th step: Granting user permission

Copy Code code as follows:

Grant CONNECT,RESOURCE,DBA to username;