Space usage from dba_segments

We have a 19c database. We are trying to export a user's objects using datapump. When we checked the space usage by the user from dba_segments we got space used by the user as 3.3Gb:

  1 select owner, TABLESPACE_NAME, sum(bytes)/1024/1024/1024/1024 Gb from dba_segments
  2* where owner IN ('&owner') group by owner, TABLESPACE_NAME SQL> /
Enter value for owner: DW_USER
old 2: where owner IN ('&owner') group by owner, TABLESPACE_NAME new 2: where owner IN ('DW_USER') group by owner, TABLESPACE_NAME

OWNER TABLESPACE_NAME GB
-------------- -------------------- ----------

DW_USER         DW_TEAM                   3.3

1 row selected.

###################################################

We are currently running the data pump for the user and the dump file is about 600Gb already and the job is still running. Does dba_segments not show all space used by a user ? Is there another view where I can see all the space used by a certain user.

Thanks,
CP.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 08 2021 - 18:30:56 CET