You created a tablespace with this statement:CREATE BIGFILE TABLESPACE adtbs -DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You created a tablespace with this statement:CREATE BIGFILE TABLESPACE adtbs -DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G

Post by answerhappygod »

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;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply