Creation of Oracle Tablespace

Note the point:

1. If it is opened in a tool such as PL/SQL, directly modify the following code [ Italic bold Section ] to execute

2. Ensure that the path exists, such as "D:\oracle\oradata\Oracle9i\", which is the path where you want to save the file

/ * divided into four steps * /

/* Step 1th: Create a temporary tablespace */

Create temporary tablespace user_temp

Tempfile ' D:\oracle\oradata\Oracle9i\user_temp.dbf '

Size 50m

Autoextend on

Next 50m maxsize 20480m

Extent management Local;

/ * Step 2nd: Create a data table space * /

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 * /

Create user username identified by password

Default tablespace user_data

Temporary tablespace user_temp;

/ * Step 4th: Grant permissions to users * /

Grant CONNECT,RESOURCE,DBA to username;

Reference: http://www.cnblogs.com/netsql/articles/1745978.html