Re: No such file or directory error while creating Temporary Tablespace

1. You seem to have syntax errors.
2. Double check the existance/path of the directory you specified, along with permissions. The 'touch' command works great to verify such a thing.

Try this out. Re-write/tune as needed. This is just an example.

CREATE TEMPORARY TABLESPACE TEMP03
TEMPFILE '/u02/oradata/orcl/temp03.dbf' SIZE 1M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024 / Received on Thu Feb 21 2002 - 10:25:12 CST