Re: rebuild indexes
- From: Andy Gmail <andrew.kerber@xxxxxxxxx>
- To: "Brian.Zelli@xxxxxxxxxxxxxxx" <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Fri, 18 Apr 2014 13:05:59 -0500
Yes. Just run alter table move tablespace whatever then rebuild the indexes.
That will accomplish what you need.
Sent from my iPhone
> On Apr 18, 2014, at 12:37 PM, "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
> wrote:
>
> One table has 14 rows and the other has 26. They say it is causing
> performance issues……
>
>
> Brian
>
>
> From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
> Sent: Friday, April 18, 2014 1:37 PM
> To: Zelli, Brian
> Cc: oracle-l (oracle-l@xxxxxxxxxxxxx)
> Subject: Re: rebuild indexes
>
> How big is the table? He probably wants you to shrink it by eliminating
> unused blocks. The simplest way to do that is by an alter table move command
> followed by alter index rebuild.
>
> Sent from my iPad
>
> On Apr 18, 2014, at 12:26 PM, "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
> wrote:
>
> A vendor wants me to shrink a table. I’ve never shrunk one in oracle. Does
> that delete the data out of them?
> And then wants me to rebuild the associated indexes. Won’t they be empty
> after you shrink them?
>
>
> Brian
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
Other related posts:
