手工重置数据文件的大小

1.查询一下longshen表空间的基本信息
SQL> select file_id,file_name,tablespace_name,bytes/1024/1024 MB from
  2  dba_data_files where tablespace_name like 'LONGSHEN';             

FILE_ID FILE_NAME                           TABLESPACE_NAME         MB
------- ----------------------------------- --------------- ----------
      6 /oradata/law/law/longshen01.dbf     LONGSHEN                15
      7 /oradata/law/law/longshen02.dbf     LONGSHEN                15

2.将数据文件longshen01.dbf 的大小加大到30M.
SQL> alter database datafile '/oradata/law/law/longshen01.dbf' resize 30M;

Database altered.

3.查询一下是否修改成功
SQL> select file_id,file_name,tablespace_name,bytes/1024/1024 MB from
  2  dba_data_files where tablespace_name like 'LONGSHEN';

FILE_ID FILE_NAME                           TABLESPACE_NAME         MB
------- ----------------------------------- --------------- ----------
      6 /oradata/law/law/longshen01.dbf     LONGSHEN                30
      7 /oradata/law/law/longshen02.dbf     LONGSHEN                15

4.给longshen表空间添加一个数据文件

SQL> alter tablespace longshen
  2  add datafile '/oradata/law/law/longshen03.dbf' size 15m;

Tablespace altered.

5.查询一下是否添加成功

SQL> select file_id,file_name,tablespace_name,bytes/1024/1024 MB from dba_data_files
  2  where tablespace_name like 'LONGSHEN';

FILE_ID FILE_NAME                           TABLESPACE_NAME         MB
------- ----------------------------------- --------------- ----------
      6 /oradata/law/law/longshen01.dbf     LONGSHEN                30
      7 /oradata/law/law/longshen02.dbf     LONGSHEN                15
      9 /oradata/law/law/longshen03.dbf     LONGSHEN                15

6.