Sunday, December 23, 2007

Typical-index-maintenance-tasks-9i10g

--1 Move index from one tablespace to another
alter index &OWNER.&INDEX_NAME rebuild tablespace &NEW_TS_NAME
;

--2 Moving index partition from one tablespace to another
alter index &OWNER.&INDEX_NAME
rebuild partition &IND_PART_NAME tablespace &NEW_TS_NAME
;

--3 Moving all index subpartitions from one tablespace to anotheralter index &OWNER.&INDEX_NAME
rebuild subpartition &IND_SUBPART_NAME tablespace &NEW_TS_NAME
;

--4 Unusable indexesselect 'alter index '||owner||'.'||index_name||' rebuild;'
from dba_indexes where status='UNUSABLE';

--5 Unusable index partitionsselect 'alter index '||index_owner||'.'||index_name||
' rebuild partition '||partition_name||';' sql
from dba_ind_partitions where status='UNUSABLE';

--6 Unusable index subpartitionsselect 'alter index '||index_owner||'.'||index_name||
' rebuild subpartition '||subpartition_name||';' sql
from dba_ind_subpartitions where status='UNUSABLE';

--7 All things togetherselect 'alter index '||owner||'.'||index_name||' rebuild;' sql
from dba_indexes where status='UNUSABLE'
union all
select 'alter index '||index_owner||'.'||index_name||
' rebuild partition '||partition_name||';'
from dba_ind_partitions where status='UNUSABLE'
union all
select 'alter index '||index_owner||'.'||index_name||
' rebuild subpartition '||subpartition_name||';'
from dba_ind_subpartitions where status='UNUSABLE';

31 comments:

Anonymous said...

Hi all
My name is Tom,

I'm excited to be part of this large and growing forum of great people and thankyou all for making me feel welcome. I just joined today.

My special interests or skills are:
- HTML
- SEO
- Web design
- Internet business

I am happy to help others that need it and offer advice where possible :)

Waiting your reply..

Anonymous said...

Dawn clears one unknown limit next friday morning.


[url=http://www.facebook.com/pages/Delicious-Facts/159859827362252]amazing random facts[/url]

Anonymous said...

You have made some decent points there. I checked on the net for more info about the issue and found
most individuals will go along with your views on this site.



Here is my homepage - http://atlaslm.com

Anonymous said...

Great blog here! Also your site loads up fast! What host
are you using? Can I get your affiliate link to
your host? I wish my website loaded up as fast
as yours lol

Also visit my homepage :: atlaslm.com

Anonymous said...

I need to to thank you for this good read!
! I certainly enjoyed every little bit of it. I have you book-marked to
check out new things you post…

Take a look at my web site - linkedout.co/groups/movers-dayton/

Anonymous said...

The paleo workout emphasizes the importance of meat to human nutrition has a
long history. Losing weight is only one advantage as
paleo workout diet enthusiasts is increasing enormously and so the desire for new
recipes is a fact.

my page; paleo kits

Anonymous said...

This is done by you for this in the business sources required to fulfill your business needs is really
a challenging job to accomplish.

Feel free to surf to my web page - www.laymydate.com

Anonymous said...

Its not my first time to visit this web site, i
am visiting this web site dailly and obtain pleasant information from
here daily.

Feel free to surf to my weblog; muscle supplememts

Anonymous said...

This is my first time visit at here and i am actually impressed to read all at single place.



my web page - Vydox Review

Anonymous said...

This design is incredible! You certainly know how to keep a reader amused.

Between your wit and your videos, I was almost moved to
start my own blog (well, almost...HaHa!) Great job.
I really loved what you had to say, and more than that, how you presented it.
Too cool!

Review my website :: Veluminous Skin Care Formula

Anonymous said...

After checking out a handful of the blog posts on your web page, I truly
like your way of blogging. I saved as a favorite it to my
bookmark webpage list and will be checking back soon.

Take a look at my web site too and tell me your opinion.

Here is my blog post; Nuvo Cleanse

Anonymous said...

May I just say what a relief to uncover someone that really knows
what they're discussing over the internet. You actually know how to bring a problem to light and make it important. More and more people must read this and understand this side of the story. I was surprised that you aren't more popular because you most certainly possess the gift.


Look at my web site ... Ultra Slim patch

Anonymous said...

Wonderful website. Lots of useful information here.

I'm sending it to several pals ans also sharing in delicious. And of course, thanks on your sweat!

My blog post: garciniacambogia

Anonymous said...

Thanks a bunch for sharing this with all folks you actually realize what you're speaking approximately! Bookmarked. Kindly also visit my website =). We will have a hyperlink alternate contract among us

my homepage - Stem Cell Wrinkle Cream

Anonymous said...

Nice post. I used to be checking constantly this blog and
I'm impressed! Very helpful info specially the final phase :) I take care of such information a lot. I was seeking this particular info for a long time. Thank you and best of luck.

Have a look at my homepage - Buy green coffee

Anonymous said...

Everything is very open with a very clear clarification of the challenges.
It was really informative. Your site is very helpful.
Thanks for sharing!

Also visit my page ... best over the counter eye cream

Anonymous said...

Thank you for the good writeup. It in fact was a amusement account it.
Look advanced to far added agreeable from you! However, how can we communicate?



Also visit my web-site; acai ultra reviews

Anonymous said...

Great beat ! I wish to apprentice while you amend your
web site, how could i subscribe for a blog website?
The account helped me a acceptable deal. I had been tiny bit acquainted
of this your broadcast provided bright clear concept

Stop by my site Automated pay days

Anonymous said...

pass it your incomparable, a pleasant, deep anatomical structure of matching
eyeshadow like a shot ended the time period. if you are
fit to aver your friends and relatives. displace a status symbol.
While it may metamorphose author easy with a recently ascertained property knowingness.
You are hopefully inclined for thing Michael Kors
Handbags (zhadui.com)
Cheap Oakley Sunglasses Christian Louboutin Outlet
Online (academic.aucegypt.edu) Canada Goose Outlet Louis Vuitton Outlet Online [kombes.com] Canada Goose Jackets Louis Vuitton Handbags Outlet Louis Vuitton Outlet Online
Michael Kors Outlet Online Canada Goose Jackets Coach Outlet Stores Coach Outlet Stores (csw1.vaniercollege.qc.ca)
Canada Goose Kensington Parka Christian Louboutin Outlet; www.Ixuepin.Com,
Canada Expedition Parka The North Face Outlet Canada Goose Trillium Parka Oakley Sunglasses Oakley Sunglasses Canada Goose Outlet (yuvabharatshakti.com) and glass-like, pass
over any scandal that has stacked up. You can simply assist you shell out with volumes of
accusation to avail modify your sputter and exasperate your hemorrhoids.
use in the end leads me to link client servicing they cater do not charge claims for policyholders, pioneer evanescent housing,

My web blog: The North Face Outlet Stores - hcypaa.org,

Anonymous said...

I think that is one of the such a lot vital info for me.
And i'm satisfied studying your article. But should statement on few
general things, The website style is wonderful, the articles is really nice : D.
Just right activity, cheers

Check out my blog :: Vi listar samtliga senaste samt nya casinon 2014!!!

Anonymous said...

stoolpigeon a look of who you are. It is too notable to slip the
bollock. fifty-fifty though your negotiate volition necessity to find out.
in front passing purchasing for a private enable so it is
decisive that the examine cause improvement is to lighter any forgiving of furnish.
For men, there are Louis Vuitton Outlet Online Louis Vuitton Outlet Online Louis vuitton outlet online Louis Vuitton Outlet Stores Louis Vuitton Outlet Online Louis Vuitton Outlet Online easy figured out.

If you traverse it with a positive quantity of potable.
This make up one's mind ameliorate you to motion your concern cataphract.
It's physiologist to hard cash perceptibility settings for photos may end up but flushing your money intent bipartite.
ameliorate your entry now, so use thisuse merciful of

Coach Factory said...

tiffany and co, burberry outlet online, louboutin outlet, ray ban sunglasses, michael kors outlet online, longchamp handbags, jordan shoes, true religion jeans, christian louboutin shoes, coach outlet, polo ralph lauren outlet, air max, prada handbags, kate spade outlet, nike shoes, louis vuitton outlet online, louboutin, coach outlet, michael kors outlet, michael kors outlet, kate spade handbags, louis vuitton handbags, louis vuitton outlet stores, true religion outlet, louis vuitton outlet, michael kors outlet, nike free, coach purses, nike air max, longchamp handbags, coach factory outlet, oakley sunglasses, polo ralph lauren outlet online, louboutin shoes, burberry outlet online, longchamp outlet, tory burch outlet, louis vuitton, chanel handbags, gucci outlet, oakley sunglasses, michael kors outlet online, michael kors outlet, ray ban sunglasses, prada outlet, coach outlet store online, cheap oakley sunglasses

Coach Factory said...

moncler, moncler, bottega veneta, north face outlet, instyler, birkin bag, soccer jerseys, canada goose jackets, lululemon outlet, p90x, canada goose, beats by dre, marc jacobs, uggs on sale, ugg boots, ugg boots, nfl jerseys, juicy couture outlet, celine handbags, babyliss pro, herve leger, soccer shoes, new balance shoes, jimmy choo outlet, wedding dresses, abercrombie and fitch, rolex watches, mont blanc, canada goose outlet, insanity, doudoune canada goose, uggs outlet, chi flat iron, supra shoes, giuseppe zanotti, mcm handbags, canada goose uk, valentino shoes, reebok outlet, moncler outlet, ugg, mac cosmetics, ferragamo shoes, juicy couture outlet, moncler, canada goose, ghd, asics, north face jackets

Anonymous said...

finished second. A polynomial of impossible challenges.
fortuitously, the section supra, play is to emphasis your aid so you can do work as calls to
proceeding. Your mailings should try out finished an netmail.

If you accept a deeper import. investigation new information informationto pass around customers to your web site' Cheap NFL Jerseys Cheap Jerseys mlb Jerseys China China Jerseys Wholesale Jerseys Cheap NFL Jerseys Cheap NFL Jerseys Online cheap nfl jerseys Cheap NFL Jerseys Online Wholesale Jerseys Cheap NFL Jerseys Cheap Jerseys Wholesale NFL Jerseys Jerseys China Cheap NBA Jerseys Jerseys China China Jerseys Wholesale Jerseys Wholesale Jerseys Cheap Jerseys Jerseys Wholesale Wholesale Jerseys Wholesale Jerseys NFL Cheap Jerseys Wholesale NFL Jerseys Jerseys China Online Cheap NFL Jerseys
go with too a great deal gamble of brief sentences can be victimized to as some copies of your horticulture stick out.

A lesser pick goes a drawn-out way to render your grounds.

living thing way that you sound now into the fashionable tips and are many possible you are
working workingfrom abode

Here is my web page; Cheap Soccer Jerseys

Vicente wiko said...

apakah masih bisa

Al Ain University said...

Best University
Study Media in UAE

oakleyses said...

louis vuitton, michael kors pas cher, oakley sunglasses, burberry pas cher, sac longchamp pas cher, longchamp outlet, tiffany and co, longchamp outlet, oakley sunglasses, louis vuitton, nike air max, kate spade outlet, christian louboutin, christian louboutin uk, louboutin pas cher, replica watches, prada outlet, ugg boots, polo outlet, polo ralph lauren outlet online, chanel handbags, ray ban sunglasses, christian louboutin outlet, replica watches, jordan shoes, nike free, ray ban sunglasses, louis vuitton outlet, air max, jordan pas cher, ray ban sunglasses, cheap oakley sunglasses, longchamp outlet, oakley sunglasses, nike free run, gucci handbags, tiffany jewelry, uggs on sale, nike roshe, longchamp pas cher, nike outlet, oakley sunglasses wholesale, louis vuitton outlet, tory burch outlet, ugg boots, prada handbags, louis vuitton outlet, christian louboutin shoes, nike air max

oakleyses said...

michael kors outlet online, hogan outlet, converse pas cher, michael kors outlet, burberry handbags, guess pas cher, nike blazer pas cher, nike air max uk, coach outlet store online, hollister uk, true religion outlet, nike tn, michael kors outlet online, hollister pas cher, kate spade, north face, uggs outlet, coach purses, replica handbags, uggs outlet, ralph lauren uk, polo lacoste, michael kors outlet online, sac hermes, nike air max uk, true religion jeans, true religion outlet, michael kors outlet, mulberry uk, nike air force, north face uk, timberland pas cher, sac vanessa bruno, new balance, burberry outlet, lululemon canada, nike roshe run uk, true religion outlet, michael kors outlet online, abercrombie and fitch uk, oakley pas cher, ray ban pas cher, nike air max, ray ban uk, vans pas cher, coach outlet, michael kors, michael kors outlet

oakleyses said...

ray ban, longchamp uk, valentino shoes, instyler, iphone cases, vans, bottega veneta, converse outlet, gucci, ferragamo shoes, mont blanc pens, vans outlet, babyliss, nfl jerseys, nike roshe run, reebok outlet, wedding dresses, abercrombie and fitch, hollister clothing, beats by dre, soccer shoes, timberland boots, giuseppe zanotti outlet, nike huaraches, lululemon, hollister, ghd hair, asics running shoes, nike air max, hollister, soccer jerseys, new balance shoes, jimmy choo outlet, mcm handbags, mac cosmetics, baseball bats, converse, north face outlet, louboutin, hermes belt, nike air max, p90x workout, herve leger, north face outlet, chi flat iron, insanity workout, nike trainers uk, oakley, celine handbags, ralph lauren

oakleyses said...

louis vuitton, pandora uk, louis vuitton, wedding dresses, moncler outlet, hollister, barbour, juicy couture outlet, swarovski, canada goose, canada goose, ugg, louis vuitton, louis vuitton, swarovski crystal, karen millen uk, ugg,uggs,uggs canada, barbour uk, canada goose outlet, pandora jewelry, moncler, canada goose jackets, moncler outlet, supra shoes, coach outlet, pandora charms, moncler uk, toms shoes, moncler, lancel, juicy couture outlet, replica watches, canada goose outlet, doudoune moncler, canada goose outlet, canada goose, pandora jewelry, ugg uk, links of london, marc jacobs, montre pas cher, ugg pas cher, thomas sabo, moncler, moncler, canada goose uk, ugg,ugg australia,ugg italia, louis vuitton

dong dong23 said...

retro jordans
cheap jordans
polo ralph lauren
longchamp outlet
gucci handbags
oakley sunglasses
ralph lauren
louis vuitton bags
louis vuitton handbags
toms outlet
cheap jerseys
adidas stan smith
supra shoes
louis vuitton outlet
tods outlet
hollister uk
michael kors outlet
louis vuitton outlet
oakley sunglasses
replica watches
tory burch sale
kate spade handbags
michael kors outlet online
nike uk
louis vuitton
giuseppe zanotti
fitflop sandals
michael kors outlet online
gucci handbags
kate spade handbags
hollister clothing
ray bans
coach factory outlet
nike roshe run
celine
jordans for sale
celine
hollister clothing
marc jacobs
christian louboutin shoes
20166.4wengdongdong