Drs_data tablespace insufficiency problem: Description OCIErrorORA-01691: unabletoextendlobsegmentGIONEE_DRS.SYS_LOB00000855 failed through 8192 (
Drs_data tablespace insufficiency problem: Description OCI Error ORA-01691: unable toextend lob segment GIONEE_DRS.SYS_LOB00000855 failed to pass 8192 (
Insufficient drs_data tablespace:
Description OCI Error ORA-01691: unable toextend lob segment GIONEE_DRS.SYS_LOB00000855 cannot be extended through 8192 (in tablespace USERS.
The following method adds a '/data/oradata/datafile/drs_data0002.dbf' file for the tablespace to expand the tablespace. The size of the added file drs_data0002.dbf is 30720 MB, of course, the size and file path can be changed.
Altertablespace drs_data add datafile '/data/oradata/datafile/drs_data0002.dbf' size 30720 m;
Altertablespace drs_data add datafile '/data/oradata/datafile/drs_data0003.dbf' size 30720 m;
Altertablespace drs_data add datafile '/data/oradata/datafile/drs_data0004.dbf' size 30720 m;
Related reading:
Oracle ORA-01555 snapshot old description
Troubleshooting for ORA-01078 and LRM-00109
ORA-01555 ultra-long Query Duration time
Notes on ORA-00471 Processing Methods
ORA-00314, redolog corruption, or loss Handling Method
Solution to ORA-00257 archive logs being too large to store