When using Oracle, you run across an error in the log file similar to: "Visibility archive: ORA-01691: unable to extend lob segment VISIBILITY.SYS_LOB0000023860C00002$$ by 128 in tablespace <TABLESPACE_NAME>"
This happens when the user that was created for the Visibility schemas has a restricted size on that users tablespace. To fix the problem, you can run the following commands as the SYSTEM user on your database server:
- Start SQLPlus. Login with the SYSTEM credentials.
-
Run:
SELECT * FROM dba_tablespace_usage_metrics order by used_percent desc;
-
Find the TABLESPACE_NAME where USED_PERCENT is close to being full.
-
-
Run:
SELECT df.tablespace_name, df.file_name FROM dba_data_files df;
-
Get the FILE_NAME that matches the TABLESPACE_NAME from the previous step.
-
-
Run:
ALTER DATABASE DATAFILE '<FILE_NAME>' AUTOEXTEND ON MAXSIZE UNLIMITED;
-
Substitute <FILE_NAME> for the FILE_NAME value from the previous step.
-
- Rerun Export.
This allows the datafile to grow as needed. Alternatively you could add another datafile to the tablespace or extend
the space of the existing datafile. For these options, consult with your Oracle database administrator.