Solutions to ORA-01691 problems with IMP import data

Problem description: Oracle error 1691 is reported when data is imported through imp today.

ORA-01691: Lob segment MID. SYS_LOB0000032765C00002 $ unable to scale through 1024 (in tablespace MID)

Cause of the problem: I searched for it on the Internet and learned that this problem was caused by insufficient tablespace capacity.

Solution: Expand the tablespace

Additional Remarks: to increase the tablespace size, you can set it on the em console, or use SQL.

Select tablespace_name, file_name, autoextensible from dba_data_files where tablespace_name = 'mid ';

We can see that autoextensible = NO

Then execute the SQL statement

Alter database datafile '/ORACLE/ORACLEDATA/ORCL/MID. ORA' autoextend on;

Try imp again to solve the problem.