Database Administration (MOSC)

MOSC Banner

unable to resize bigfile the size has reached 2TB

edited Jan 2, 2016 11:46PM in Database Administration (MOSC) 10 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center