Exam Prep Questions

1:You issue the command 
ALTER TABLESPACE TEMP ADD DATAFILE '/mydatabases/mydb1/temp02.dbf' 100M;

and you receive the error

ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

What is the problem with the statement?

  • A. You didn't specify any storage specifications.

  • B. You can't add a data file to a temporary tablespace.

  • C. You can't add a data file to a temporary tablespace with the ALTER TABLESPACE command.

  • D. You specified an invalid location for the file.

A1: Answer C is correct. You must use the ALTER DATABASE command to add a tempfile to the temporary tablespace. Answer A is incorrect because you don't have to specify any storage specifications when you add a data file to an existing tablespace. It takes on the ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial