Create Tablespace error!

[amitstora]

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.

[Calvin_Qiu]

Definitely B.

[amitstora]

Hi calvin_Qiu!

Many Thanks for taking out time to answer.

Regards,

Amit.