Hi all!

I dont have much exposure on Oracle v9i but would like to share experienced guys knowledge there:

Query:

1.CREATE TABLESPACE ABC;

Oracle error:missing datafile/tempfile.

Which options should I select from the undermentioned choices:

a).CREATE TABLESPACE ABC DATAFILE 100M; command.
b).SET UP DB_CREATE_FILE_DEST and then pass the command.
(So that datafile would be automatically be created)
Regards,

Amit.