CAD connection alarm system recording playback failed

Dear user,

It is possible that the Oracle database tablespace is full, resulting in read and write exceptions.

1.Use the following statement to query table space usage:

select
total.tablespace_name tsname,
count(free.bytes) nfrags,
nvl(max(free.bytes)/1024,0) mxfrag,
total.bytes/1024 totsiz,
nvl(sum(free.bytes)/1024,0) avasiz,
(1-nvl(sum(free.bytes),0)/total.bytes)*100 pctusd
from
dba_data_files total,
dba_free_space free
where
total.tablespace_name = free.tablespace_name(+)
and total.file_id=free.file_id(+)
group by
total.tablespace_name,
total.bytes

2.If the table space is confirmed to be full, use the following statement to modify the table space.

Add data files to increase tablespaces. 

Run the following commands: 

SQL> alter tablespace TABLESAPCENAME add datafile 'filePath' size SPACESIZE;

• TABLESAPCENAME: name of the tablespace.

• filePath: path and name of the data file allocated to the tablespace. 

To obtain the new file path, run the select name from v$datafile; command to view the path of similar data files.

• SPACESIZE: space size to be allocated.

Command example:

SQL> alter tablespace CBP_TABLE_SPACE add datafile '+DG_DATA/rdata90' size 1950m;