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

From: Siddharth <siddharthbahri_at_yahoo.com>
Date: 21 Feb 2002 23:18:01 -0800
Message-ID: <fede6a7c.0202212318.2785f4ce@posting.google.com>

Hi,

Thanks norwood and raghu for the reply. Indeed the syntax was wrong.

The following statement worked:

SQL> CREATE TEMPORARY TABLESPACE TEMP03 TEMPFILE '/u02/oradata/orcl/temp03.dbf' SIZE 4M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4096;
Tablespace created.

Rgds.
Siddharth

norwoodthree_at_my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0202210825.61c79ec_at_posting.google.com>...
> 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 Fri Feb 22 2002 - 01:18:01 CST