ORA-1691: Unable to extend lob segment

Question

I am loading from one oracle bank to another bank and at the time of transferring the files from an Attachment table this error occurred after some time: ORA-1691.

Reading a little I saw that it has relation with storage space but I do not know how to verify the current size nor what to request the infra team. Would it be "increasing tablespace"? But for how many MB should I ask for this increase?

You can check this via select in the bank without being Wner?

Answer 1

To know the size of a tablespace it is necessary to know the size of the data files that constitute this tablespace. For this we can use the following querys to check the size of a database. - Seat size

select sum(bytes) / 1024 / 1024 / 1024 tamanho_GB from dba_segments;

- or

select sum(bytes) /1073741824  TAMANHO_GB from dba_segments;

- Size by Tablespace

select tablespace_name, sum(bytes) / 1024 / 1024 / 1024 tamanho_GB from dba_segments group by tablespace_name;