Using El to create a tablespace

Note:

1. If you open it in PL/SQL or other tools, directly modify the following code[Italic bold section]Run

2. Make sure that the path exists, for example, [D: \ oracle \ oradata \ Oracle9i \], that is, the path of the file to be saved exists.

/* Divided into four steps */

/* Step 2: create a temporary tablespace */

Create temporary tablespaceUser_temp

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

Size 50 m

Autoextend on

Next 50 m maxsize 20480 m

Extent management local;

/* Step 2: create a data table space */

Create tablespaceUser_data

Logging

Datafile 'd: \ oracle \ oradata \ Oracle9i \ user_data.dbf'

Size 50 m

Autoextend on

Next 50 m maxsize 20480 m

Extent management local;

/* Step 2: create a user and specify the tablespace */

Create userUsernameIdentifiedPassword

Default tablespaceUser_data

Temporary tablespaceUser_temp;

/* Step 4: grant permissions to users */

Grant connect, resource, DBAUsername;

The following code is the same as above and can be copied directly.

/* Divided into four steps * // * Step 4: create a temporary tablespace */create temporary tablespace user_temp tempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf 'size 50 m autoextend on next 50 m maxsize 20480 M extent management local;/* Step 4: create a data table space */create tablespace user_data logging datafile 'd: \ oracle \ oradata \ Oracle9i \ user_data.dbf 'size 50 m autoextend on next 50 m maxsize 20480 M extent management local; /* Step 2: create a user and specify the tablespace */create user username identified by password default tablespace user_data temporary tablespace user_temp;/* Step 2: grant the user permissions */grant connect, resource, DBA to username;

Using El to create a tablespace