Oracle Database Add Table space

Extended table Space Size statement

1. Add a data file to the tablespace:

Dba_data_files

ALTER tablespace Users

ADD datafile '/u02/oracle/rbdb1/users03.dbf ' SIZE 10M

Autoextend on

NEXT 512K

MAXSIZE 250M;

2. Adjust the size of the data file:

ALTER DATABASE datafile '/u02/oracle/rbdb1/stuff01.dbf '

RESIZE 100M;

3. Enable or disable automatic extension of data files:

ALTER DATABASE datafile '/u02/oracle/rbdb1/users03.dbf '

Autoextend OFF;

Oracle creating tablespaces is something we often use, and here's a detailed description of how Oracle creates table spaces, and hopefully it will help you learn how Oracle creates tablespaces.

Create a temporary table space

Create temporary tablespace test_temp

Tempfile ' E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf '

Size 32m

Autoextend on

Next 32m MaxSize 2048m

Extent management Local;

Create a data table space

Create Tablespace Test_data

Logging

DataFile ' E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf '

Size 32m

Autoextend on

Next 32m MaxSize 2048m

Extent management Local;

Create a user and specify a tablespace

Create user username identified by password

Default Tablespace test_data

Temporary tablespace test_temp;

Granting permissions to Users

Grant Connect,resource to username;

Any database objects that you create later with that user are part of the test_temp and test_data table spaces, and you do not have to specify a tablespace for each object you create.

Table null off Auto Grow

ALTER DATABASE datafile autoextend off;

This article is from the "Beijing-East" blog, please be sure to keep this source http://bjdong.blog.51cto.com/507460/1718624

Oracle Database Add Table space