Re: In 10g, Identifying Tables for Reorg and Compression
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sat, 18 Sep 2010 21:56:51 +0200
Message-ID: <4c95188b$0$5295$ba620e4c_at_news.skynet.be>
Mladen Gogala schreef:
> On Sat, 18 Sep 2010 12:10:50 +0200, Gerard H. Pille wrote:
>
>> Thank you for your advice, mr. Gogala. We've truncated all large tables
>> and the results are astounding, the queries are fast as lightning. But
>> we seem to have another problem now, in that they are not returning any
>> rows, not even for a simple "select * from ...". After the truncate, is
>> there something we have to do to enable selects again?
>
> You should seek the mighty Oz and ask him for a brain.
>
>
>
I'd be the last to complain
About what I've got for a brain,
But I could do with a heart,
and some courage for a start. Received on Sat Sep 18 2010 - 14:56:51 CDT
Date: Sat, 18 Sep 2010 21:56:51 +0200
Message-ID: <4c95188b$0$5295$ba620e4c_at_news.skynet.be>
Mladen Gogala schreef:
> On Sat, 18 Sep 2010 12:10:50 +0200, Gerard H. Pille wrote:
>
>> Thank you for your advice, mr. Gogala. We've truncated all large tables
>> and the results are astounding, the queries are fast as lightning. But
>> we seem to have another problem now, in that they are not returning any
>> rows, not even for a simple "select * from ...". After the truncate, is
>> there something we have to do to enable selects again?
>
> You should seek the mighty Oz and ask him for a brain.
>
>
>
I'd be the last to complain
About what I've got for a brain,
But I could do with a heart,
and some courage for a start. Received on Sat Sep 18 2010 - 14:56:51 CDT