Re: Tablespace Trouble

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sun, 25 Apr 1999 18:43:35 +0200
Message-ID: <7fvh01$e0c$1@news1.skynet.be>

I believe you're mixing tables and tablespaces. Coalescing may help if a lot of tables or indexes have been deleted. Reducing the next extent to an acceptable value and setting percent_increase to zero is the quickest solution, but not on long term if the amount of data keeps increasing. Export and import is the best to reorganise data and indexes. Last but maybe not least: add a datafile to your tablespace.

May the force be with you.

Gerard
a_merar_at_my-dejanews.com heeft geschreven in bericht <7ftalb$m9h$1_at_nnrp1.dejanews.com>...
>
>
>Hello,
>
>I ran a query against our production instance. This query was to show me
the
>tablespaces where the next entent was larger than the free space left in
the
>tablespace. There were 10 tablespaces listed.
>
>How do I correct this? Should I coalesce the table? Perhaps exporting the
>objects, dropping and importing them? Or do I just entend the tablespace?
>
>I'm not sure which is the correct one to do.
>
>Any suggestions would be appreciated. Please send a copy to my e-mail.
>
>Thanks,
>
>Arthur
>amerar_at_unsu.com
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun Apr 25 1999 - 11:43:35 CDT