tablespace datafile size
we have database which previously resided in EXADATA and then moved to a standalone linux host in which im seeing undo datafile size as 100g,as far as i know normal tablespaces wouldnt exceed 32g size of datafile unless it is a bigfile tablespace,i see this weird situation where normal tablespace has 100g size..
is that possible to have datafile size like this..?
SQL> SELECT tablespace_name, bigfile FROM dba_tablespaces;
TABLESPACE_NAME BIGFILE
------------------------------ ------------
UNDOTBS1 NO
FILE_NAME SUM(BYTES/1024/1024/1024)
--------------------------------------------------- ------------------------------
data_D-OBIAPRD_I-1778060744_TS-UNDOTBS2_FNO-11_p8nkgims 100
Thanks!