ORA-1691: unable to extend lob segment

0

I'm doing a load from one oracle database to another database 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 is related to storage space but I do not know how to check the current size or what to ask the infra staff. Would it be "increase the tablespace"? But how many MB should I ask for this increase?

Is it possible to query this via select in the bank without being owner?

    
asked by anonymous 17.11.2016 / 14:19

1 answer

1

To know the size of a tablespace, you need to know the size of the data files that make up this tablespace. For this we can use the following queries to check the size of a database. - Bank 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;
    
17.11.2016 / 14:32