Create a tablespace in Oracle

Create a tablespace in Oracle

Note:

1. If you open it in PL/SQL or other tools, directly modify the [italic bold part] in the following code to execute

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 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 2: 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 4: grant permissions to users */

Grant connect, resource, dba to username;

The Undo tablespace cannot be opened because it is damaged.

How to handle Undo tablespace failures

Oracle Undo tablespace reconstruction and restoration

Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian