To check Bigdata status:
SQL> select Name,BIGFILE from v$tablespace where name='APPS_TS_DATA';
NAME BIG
------------------------------ ---
APPS_TS_DATA YES
alter tablespace APPS_TS_DATA AUTOEXTEND ON MAXSIZE 62485M;
Value to add = Current value/ 0.75
alter tablespace APPS_TS_DATA AUTOEXTEND ON MAXSIZE 2204533M;
SQL> select Name,BIGFILE from v$tablespace where name='APPS_TS_DATA';
NAME BIG
------------------------------ ---
APPS_TS_DATA YES
alter tablespace APPS_TS_DATA AUTOEXTEND ON MAXSIZE 62485M;
Value to add = Current value/ 0.75
alter tablespace APPS_TS_DATA AUTOEXTEND ON MAXSIZE 2204533M;
No comments:
Post a Comment