You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE ‘/proddb/data/adtbs.dbf’ SIZE 10G; The tablespace is nearly full and you need to
avoid any out of space errors for the load of a 5 gig table. Which two alter statements will
achieve this?
A.
ALTER TA3LESPACE adtbs RESI2E 20G;
B.
ALTER TA3LESPACE adtbs ADD DATAFILE;
C.
ALTER TABLESPACE adtbs AUTOEXTEND ON;
D.
ALTER TA3LESPACE adtbs ADD DATAFILE ‘/proddb/data/adtbsl.dbf’ SIZE 1QG;
E.
ALTER TA3LESPACE adtbs MODIFY DATAFILE ‘/proddb/data/adtbs.dbf AUTOEXTEND
ON;
AC
AC
AC
Have anyone tested this command ALTER TABLESPACE adtbs AUTOEXTEND ON; ? Is it tablespace or datafile that should be autoextend on?