You created a tablespace with this statement:CREATE BIGFILE TABLESPACE adtbs -DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;The tablespace is nearly full and youneed to avoid any out of space errors for the load of a5 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;
You created a tablespace with this statement:CREATE BIGFILE TABLESPACE adtbs -DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G
-
- Site Admin
- Posts: 899566
- Joined: Mon Aug 02, 2021 8:13 am