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…

Question

Options

• AALTER TA3LESPACE adtbs RESI2E 20G;
• BALTER TA3LESPACE adtbs ADD DATAFILE;
• CALTER TABLESPACE adtbs AUTOEXTEND ON;
• DALTER TA3LESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
• EALTER TA3LESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

• A
  74% (20)
• B
  15% (4)
• D
  4% (1)
• E
  7% (2)

Explanation

You can't add a datafile to a bigfile tablespace. A and C seem the most likely. The syntax for E doesn't seem correct either. A & C are the correct answers. SQL> CREATE BIGFILE TABLESPACE bigfile_tbs DATAFILE SQL> '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile.dbf' SIZE 1G; Tablespace created. SQL> ALTER TABLESPACE bigfile_tbs resize 1G; Tablespace altered. SQL> ALTER TABLESPACE bigfile_tbs AUTOEXTEND ON; Tablespace altered. SQL> ALTER TABLESPACE bigfile_tbs ADD DATAFILE; ALTER TABLESPACE bigfile_tbs ADD DATAFILE ERROR at line 1: ORA-02236: invalid file name SQL> ALTER TABLESPACE bigfile_tbs ADD DATAFILE SQL> '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile2.dbf' size 10M; ALTER TABLESPACE bigfile_tbs ADD DATAFILE '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile2.dbf' size 10M ERROR at line 1: ORA-32771: cannot add file to bigfile tablespace SQL> ALTER TABLESPACE bigfile_tbs MODIFY DATAFILE SQL> '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile.dbf' AUTOEXTEND ALTER TABLESPACE bigfile_tbs MODIFY DATAFILE '/orabin/nonerp/12102_home/data/CDB/PDB1/bigfile.dbf' AUTOEXTEND ON ERROR at line 1: ORA-02142: missing or invalid ALTER TABLESPACE option

No community discussion yet for this question.