unable to resize bigfile the size has reached 2TB
Hello,
I am unable to resize bigfile fermi_other the size has reached 2TB.
SQL> select tablespace_name,BIGFILE from dba_tablespaces;
TABLESPACE_NAME BIG
------------------------------ ---
SYSTEM NO
SYSAUX NO
UNDOTBS1 NO
TEMP NO
USERS NO
FERMI_OTHER YES
2.0T fermi_other.dbf
MAXBYTES/1024/1024/1024 ONLINE_ FILE_NAME AUT
----------------------- ------- ------------------------------------------------------------ ---
2 SYSTEM /s01/oradata1/orp495/orp495_system01.dbf YES
10 ONLINE /s01/oradata1/orp495/orp495_sysaux01.dbf YES
0 ONLINE /s01/oradata1/orp495/orp495_undotbs101.dbf NO
0 ONLINE /s01/oradata1/orp495/orp495_users01.dbf NO
1900 ONLINE /s01/oradata1/orp495/fermi_dw_data.dbf YES
0 ONLINE /s01/oradata1/orp495/fermi_dw_indx.dbf NO