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

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sat, 23 Feb 2002 05:04:38 +1100
Message-ID: <1014401132.667656@bugstomper.ihug.com.au>

It might have worked, but I think you might seriously want to reconsider your sizing. Your temporary tablespace now has extents of 4K (although if you've got a 4K block size or bigger, that's not what you'd actually have ended up with... check dba_tablespaces).

Which is all very well, except that I can't believe your sort_area_size is that pathetically small, and extent sizes in temporary tablespaces are supposed to be a *multiple* of your sort_area_size, not a fraction of it.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Siddharth" <siddharthbahri_at_yahoo.com> wrote in message
news:fede6a7c.0202212318.2785f4ce_at_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 - 12:04:38 CST