"Go" Oracle CREATE TABLE Space

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

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;

The following code, as above, can be copied directly.

/*divided into four steps*//*1th Step: Create a temporary table space*/Create Temporarytablespace user_temp tempfile'D:\oracle\oradata\Oracle9i\user_temp.dbf'size 50m Autoextend on  Next50m maxsize 20480m extent management local; /*2nd Step: Create a data table space*/Createtablespace user_data Logging datafile'D:\oracle\oradata\Oracle9i\user_data.dbf'size 50m Autoextend on  Next50m maxsize 20480m extent management local; /*3rd Step: Create a user and specify a tablespace*/Create UserUsername identified byPassworddefaulttablespace user_dataTemporarytablespace user_temp; /*4th Step: Grant permissions to the user*/GrantConnect,resource,dba toUsername

"Go" Oracle CREATE TABLE Space