Oracle table space is out of process

Exception information:

Exception Information (Exception type: System.Data.OracleClient.OracleException) exception hint: Oracle Data execution exception, please contact the administrator to handle exception information: ORA - 01653  (in table space CWBASE001) extension

First look at whether the table space is automatically expanded:

SELECT T.tablespace_name,d.file_name, d.autoextensible,d.bytes,d.maxbytes,d.status from Dba_tablespaces t,dba_data_files DWHERE=d.tablespace_nameORDERby tablespace_name,file_name;

If it is not auto-scaling, change to auto-expand:

Alter Database ' C:\cwdata\CWBASE001. DBF'onNEXT 50M MAXSIZE UNLIMITED;

If it is auto-scaling, look at the table space usage: A data file of a normal table space is typically 32G maximum. If you use close to this, you need to build another data file.

SELECT UPPER(f.tablespace_name) "tablespace 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*  -,2),'990.99'"Use ratio", f.total_bytes "free Space (M)", F.max_bytes "Max Block (m)" from(SELECTTablespace_name,ROUND(SUM(BYTES)/(1024x768 * 1024x768),2) Total_bytes,ROUND(MAX(BYTES)/(1024x768 * 1024x768),2) Max_bytes fromSYS. Dba_free_spaceGROUP  bytablespace_name) F, (SELECTDD. Tablespace_name,ROUND(SUM(DD. BYTES)/(1024x768 * 1024x768),2) TOT_GROOTTE_MB fromSYS. Dba_data_files DDGROUP  byDD. Tablespace_name) DWHERED.tablespace_name=F.tablespace_nameORDER  by 4 DESC;

Another way to build a data file:

ALTERADD'C:\cwdata\CWBASE002. DBF'onNEXT 50M MAXSIZE UNLIMITED;

Oracle table space is out of process