Shulou(Shulou.com)06/01 Report--

-- create temporary tablespaces

Create temporary tablespace sunbing_temp tempfile'd:\ oracle\ data\ ygz_temp.dbf' size 50m autoextend on

Next 50m maxsize 20480m extent management local

-- create a data tablespace

Create tablespace ygz_data logging datafile'd:\ tablespace\ ygz_data.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local

-- create users and develop tablespaces

Create user ygz identified by password default tablespace ygz_data

Temporary tablespace ygz_temp

-- Grant permissions to users

Grant connect,resource,dba to ygz

Syntax:

CREATE TABLESPACE tablespace_name DATAFILE filename SIZE size [AUTOEXTEND [ON/OFF]] NEXT size

[MAXSIZE size] [PERMANENT | TEMPORARY] [EXTENT MANAGEMENT [DICTIONARY | LOCAL [AUTOALLOCATE | UNIFORM. [SIZE integer [K | M]]

Description:

TABLESPACE: specifies the name of the tablespace to be created

DATAFILE: specify the name of the file to store the data file in the table space. You need to indicate the path where the file is stored.

SIZE: specify the size of the data file

AUTOEXTEND: specifies the expansion mode of the data file. ON represents automatic extension and OFF represents non-automatic extension. If you want to specify the data file as an automatic extension, you should specify a specific size after the NEXT

MAXSIZE: specifies the maximum value when the data file is automatically extended

PERMANENT | TEMPORARY: specify the type of table space. PREMANENT refers to permanent table space. TEMPORARY refers to temporary table space. Default is permanent table space.

EXTENT MANAGEMENT DICTIONARY | LOCAL: specify the management method of the table space. DICTIONARY refers to the dictionary management method, LOCAL refers to the local management method, and the default is the local management method.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.