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.