oracle 修改sgamaxsize_oracle maxsize

Oracle maxsize

1

创建表空间chen,

自动增长，最大增长到10M

；

SQL> create tablespace chen datafile

'/u01/app/oracle/oradata/orcl/chen01.dbf' size 5M autoextend on next 1M maxsize

10M;

Tablespace created.

2

创建用户，指定默认表空间为chen

SQL> create user chen identified by chen

default tablespace chen;

User created.

SQL> alter user chen account unlock;

User altered.

SQL> grant connect,resource to chen;

Grant succeeded.

3

为用户chen

导入数据

[oracle@chen ~]$ exp scott/tiger file='/home/oracle/scott.dmp'

[oracle@chen ~]$ imp system/oracle

file='/home/oracle/scott.dmp' fromuser=scott

touser=chen

SQL> conn chen/chen

Connected.

SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID

------------------------------ -------

----------

DEPT                           TABLE

EMP                            TABLE

SALGRADE                       TABLE

4

增加数据文件

SQL> alter tablespace chen add datafile

'/u01/app/oracle/oradata/orcl/chen02.dbf' size 10M;

Tablespace altered.

SQL> alter tablespace chen add datafile

'/u01/app/oracle/oradata/orcl/chen03.dbf' size 10M;

Tablespace altered.

SQL> alter tablespace chen add datafile

'/u01/app/oracle/oradata/orcl/chen04.dbf' size 10M autoextend on next 1M maxsize

15M;

SQL> select

file_name,tablespace_name,bytes/1024/1024||'M' f,maxbytes/1024/1024||'M' m from

dba_data_files;

………………………………………

/u01/app/oracle/oradata/orcl/chen01.dbf       CHEN       5M         10M

/u01/app/oracle/oradata/orcl/chen02.dbf       CHEN       10M        0M

/u01/app/oracle/oradata/orcl/chen03.dbf       CHEN       10M        0M

/u01/app/oracle/oradata/orcl/chen04.dbf       CHEN       10M        15