ORA-01653: Problem with table space expansion failure

Today found that the original equipment data sheet space only 5 m, has been full, the Internet to find to expand space.

One, the script modifies the way:

----query Table space usage---
Log on with DBA authority
Select UPPER (f.tablespace_name) "Table space name",
D.TOT_GROOTTE_MB "Table space size (M)",
D.tot_grootte_mb-f.total_bytes "used Space (M)",
To_char (ROUND (d.tot_grootte_mb-f.total_bytes)/d.tot_grootte_mb * 100,2), ' 990.99 ') "Use ratio",
F.total_bytes "free Space (M)",
F.max_bytes "Max Block (M)"
From (SELECT Tablespace_name,
ROUND (SUM (BYTES)/(1024 * 1024), 2) Total_bytes,
ROUND (MAX (BYTES)/(1024 * 1024), 2 max_bytes
From SYS. Dba_free_space
GROUP by Tablespace_name) F,
(SELECT DD. Tablespace_name,
ROUND (SUM (DD). BYTES)/(1024 * 1024), 2 TOT_GROOTTE_MB
From SYS. Dba_data_files DD
GROUP by DD. Tablespace_name) D
WHERE D.tablespace_name = F.tablespace_name
Order by 4 DESC;
Table space Name table space Size (m) used space (m) to use more than free space (m) maximum block (m)
------------------------------ ------------- ------------- ------- ----------- ----------
...
Ccen 10 8.5 85.00 1.5.94
...
found that the table space is only 1.5M idle, guessing may be the problem of automatic expansion of tablespace (table space is too high, Oracle default is 50%), modify the table space file expansion mode:

Sql>alter DATABASE
DataFile '/u01/oracle/oradata/orcl/ccen01.dbf ' autoextend
On NEXT 50M MAXSIZE Unlimited
Solve the problem.


Ability to see if a table space has automatic expansion
SELECT T.tablespace_name,d.file_name,
D.autoextensible,d.bytes,d.maxbytes,d.status
From Dba_tablespaces t,dba_data_files D
WHERE T.tablespace_name =d.tablespace_name
Order BY Tablespace_name,file_name;

Second, the use of the console mode:

Open Oracle's Enterprise Manager to the table space to select the tablespace to modify, double-click on the table to open the editing interface, click on the pen icon, in the editing data file Interface Storage tab can modify the "data file is full after automatic expansion" modify the desired increment, and maximum value after the point of application to save.