Record of ORA-01691 error reported by Data Pump replication library, ora-01691

Record of ORA-01691 error reported by Data Pump replication library, ora-01691

Today, I want to report a database error 01691. I learned the following online: The table space is insufficient.

Based on your own error message

View the tablespace list SELECT t. tablespace_name, round (SUM (bytes/(1024*1024), 0) ts_sizeFROM dba_tablespaces t, dba_data_files dWHERE t. tablespace_name = d. tablespace_nameGROUP BY t. tablespace_name;

View the name and size of a tablespace physical file

SELECT tablespace_name,

File_id,

File_name,

Round (bytes/(1024*1024), 0) total_space

FROM dba_data_files

Order by tablespace_name;

Locate the tablespace name that reported the error

Locate the tablespace and physical address

Alter tablespace TAB_CC add datafile '/cctab/cc/newtabcc06.dbf' size5000M;

Add a tablespace to set the space size for it.

You can continue to use data to pump new users to record their daily logs.