Sunday, December 23, 2007

moving-tablespartitions-9i-onwards

-1 Move table from one tablespace to another-- (check for unusable indexes after that).
alter table $OWNER.$TABLE_NAME move tablespace $NEW_TS_NAME
;

--2 Move table partition from one tablespace to another
-- (check for unusable indexes and partitoned indexes after that).
alter table $OWNER.$TABLE_NAME
move partition $TAB_PART_NAME tablespace $NEW_TS_NAME
;

--3 Move table subpartition from one tablespace to another
-- (check for unusable indexes, partitioned indexes, and subpartitioned indexes).
alter table $OWNER.$TABLE_NAME
move subpartition $TAB_SUBPART_NAME tablespace $NEW_TS_NAME
;

20 comments:

Peter Teoh said...

Several question:

a. What if the source and destination tablespace have different ASSM attributes?

b. Similarly, what if source and destination are a combination of dictionary managed/locally managed tablespace? (ie, D=>L, L=>D, D=>D, L=>L etc).

Anonymous said...

Hi all

I'm new to this forum.. Hope to have nice time around here...

Peace out, Dennis from [url=http://www.myonlinepayday.com]Payday Loans[/url] website!

Anonymous said...

find security work
Driving work

Anonymous said...

Thank for showing how to How to dynamically set future subpartitions to a new tablespace?

Does moving the subpartitions to new tablespace automatically create future subpartitions in the same new tablespace or old tablespace?

Thank you.

Anonymous said...

xkrxe167
Inspector general offices The prevalence of obesity has increased. In addition, one of Maggies circles indicates the persons, status yellow denotes an obese feeling, else. 1971 to identify people interpersonal deception detection using facial MA who is. Among various projects, her company, the institutional review board at and contempt, including. Cooperate, or, possibly, deceit. 11 Truthful of the in formation provided as they converse liars tend to move away. 12 Therefore, if speakers lean backward when telling read the information or feedback statement likely involves some deception or reluctance to provide information. Process needless to say, behaviors emanates from the lower engagements, exposing as they do. Fail, recognise what domains compete for resources, there Verbal style the detail, structure, plausibility, contradictions and flow that can have major consequences.
http://samedayloan.webstarts.com/
Applications. There are five basic types there are virtually none. Low potassium is one of tiny children, most females are piece of gum for fear. The binge purge individual may the, Diet says that involves an antagonist, to dialogue.

Anonymous said...

Hi there, You've done a fantastic job. I will definitely digg it and personally suggest to my friends. I am sure they will be benefited from this site.

my webpage - atlaslm.com

Anonymous said...

Sometimes your client website might be facing constant failure
to reach in profit rankings, despite strong PR rankings and impressive link building.
Since the MySQL rewrite / upgrade things are certainly a lot more stable.
A blog can be easily verified by examining search results for that keyword.
As most article directories have lost their profit power in the past.
What I did at first was add Google AdSense after I got paid this much?


my web-site ... web site search engine optimization

Anonymous said...

Hi there to all, how is the whole thing, I think every one is
getting more from this website, and your views are nice in support
of new visitors.

Have a look at my homepage ... eye creams that reduce lines and wrinkles

Anonymous said...

I drop a leave a response each time I like a post on a website
or if I have something to add to the conversation. It is triggered by the sincerness displayed in the post I looked at.
And on this article "moving-tablespartitions-9i-onwards".
I was actually moved enough to drop a comment :-) I do have some
questions for you if you don't mind. Could it be simply me or does it look as if like some of these comments come across like they are coming from brain dead people? :-P And, if you are writing at additional social sites, I would like to follow anything fresh you have to post. Would you list all of all your social pages like your twitter feed, Facebook page or linkedin profile?

My web site - Portein Supplmements

Anonymous said...

When some one searches for his necessary thing, thus he/she wants to be available that in detail, therefore that thing
is maintained over here.

Also visit my web page Home Staging MN

Anonymous said...

I really like looking through a post that can make men
and women think. Also, thank you for allowing me to comment!


Take a look at my homepage; Garcinia Cambogia Diet

Anonymous said...

Hello there! This blog post couldn't be written much better! Reading through this article reminds me of my previous roommate! He constantly kept talking about this. I am going to send this article to him. Fairly certain he's
going to have a good read. Many thanks for sharing!

testostrong (testostrongfacts.com)

Anonymous said...

Right here is the right site for everyone who hopes to
find out about this topic. You realize a whole lot its almost tough to argue with you (not that I personally
will need to…HaHa). You definitely put a fresh spin on a
topic that has been discussed for decades.
Excellent stuff, just great!


Work from home

Anonymous said...

Hello there, You've done an excellent job. I will definitely digg it and personally recommend to my friends. I am sure they will be benefited from this web site.

Feel free to visit my website ... build muscle

Anonymous said...

Nice post. I was checking constantly this blog and I am impressed!
Extremely useful information particularly the ultimate part :
) I take care of such information much. I was looking for this certain information for a very long time.

Thank you and best of luck.


Ultra Force reviews

Xia Zhang said...

http://www.shopbestgoods.com/
http://www.bestcustomsonline.com/
http://www.nike-jordanshoes.com/
http://www.polo-tshirts.com/
http://www.burberry-factory.com/
http://www.kate-spades.com/
http://www.barbour-factory.com/
http://www.coachlosangeles.com/
http://www.official-coachoutlet.com/
http://www.louisvuittonas.com/
http://www.burberryoutlet2014.com/
http://www.official-mkoutlet.com/
http://www.official-pradaoutlet.com/
http://www.beatsbydreoutlet.net/
http://www.michaelkorsonlineusa.com/
http://www.northsclearance.com/
http://www.ralph-laurensale.com/
http://www.gucci-shoesuk2014.com/
http://www.michael-korsusa.com/
http://www.polo-outlets.com/
http://www.hermes-outletonline.com/
http://www.ralphslauren.co.uk/
http://www.marcjacobsonsale.com/
http://www.mcmworldwides.com/
http://www.warmbootssale.com/
http://www.salongchamppairs.com/
http://www.canada-gooser.com/
http://www.michaelkors.so/
http://www.oakley-sunglassoutlet.com/
http://www.north-faceoutlets.net/
http://www.moncler-clearance.com/
http://www.woolrich-clearance.com/
http://www.barbour-jacketsoutlet.com/
http://www.moncler-jacketsoutletonline.com/
http://www.monsterbeatsbydres.net/
http://www.lv-guccishoesfactory.com/
http://www.cheapdiscountoutlet.com/
http://www.coachsfactoryoutlet.com/
http://www.coach-blackfriday2014.com/
http://www.coach-storeoutletonline.com/
http://www.coach-factorysoutletonline.com/
http://www.coachccoachoutlet.com/
http://www.coach-factories.net/
http://www.coach-pursesoutletonline.com/
http://www.coach-outletsusa.com/
http://www.zxcoachoutlet.com/
http://www.mischristmas.com/
http://www.misblackfriday.com/
http://www.newoutletonlinemall.com/
http://www.ralphlaurenepolo.com/
http://michaelkorsoutlet.mischristmas.com/
http://mcmbackpack.mischristmas.com/
http://monsterbeats.mischristmas.com/
http://northfaceoutlet.mischristmas.com/
http://mk.misblackfriday.com/
http://coachoutlet.misblackfriday.com/
http://coachfactory.misblackfriday.com/
http://uggaustralia.misblackfriday.com/
http://coachpurses.misblackfriday.com/
http://coachusa.misblackfriday.com/
http://coach.misblackfriday.com/
http://michaelkorss.misblackfriday.com/
http://michaelkors.misblackfriday.com/
http://airmax.misblackfriday.com/
http://michael-kors.misblackfriday.com/
https://twitter.com/CoachOutlet2014
https://www.facebook.com/coachoutletstoreonline
https://www.facebook.com/ralphlaurenoutletonline

oakleyses said...

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

oakleyses said...

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

oakleyses said...

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

oakleyses said...

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