Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to extend temp on non temp tablespace

Re: Unable to extend temp on non temp tablespace

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 6 Jan 2003 09:48:23 -0000
Message-ID: <avbjds$sha$1$8300dec7@news.demon.co.uk>

Following on from Niall's comment -
it isn't really very convenient to have a single 48GB tablespace for your indexes, so you may take this opportunity to
create several small tablespaces and
distribute the indexes sensibly between them.

Do a google groups (and the FAQ) search for locally managed tablespaces for futher ideas of improving the ease of management at the tablespace level.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______January 21/23
____USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Niall Litchfield wrote in message
<3e194ddd$0$241$ed9e5944_at_reading.news.pipex.net>...

>"Rick Denoire" <100.17706_at_germanynet.de> wrote in message
>
>Yes, the problem is that the extents that are in that file are
scattered
>around the file. You will need to move the extents out of that file
and then
>either shrink or drop recreate. The best way to do this if you have
the disk
>space is to move the objects out of this tablespace temporarily (or
assuming
>they are indexes drop them) resize the datafile, and then move (or
recreate)
>the objects back. This will almost certainly require downtime.
>
>
Received on Mon Jan 06 2003 - 03:48:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US