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
;

19 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...

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

Unknown said...

michael kors outlet store
air jordan
reebok shoes
jordan shoes
nike air force 1
yeezy shoes
adidas outlet
hogan outlet online
louboutin shoes uk
adidas ultra boost

Unknown said...

michael kors handbags
nike air force 1 high
yeezy boost 350 v2
converse shoes
foamposites
kobe shoes
ysl handbags
air jordan 12
nike dunk low
longchamp bags

yanmaneee said...

off white nike
golden goose sale
yeezy shoes
curry shoes
yeezy boost 350 v2
moncler coat
curry 8
yeezy boost 350 v2
kyrie 7
kd 12

deraz said...

خدمات ابو ظبى - بيت العز
شركة تنظيف ستائر بالبخار ابوظبى
شركات تنظيف الكنب ابوظبى

Anonymous said...

kyrie 9
yeezy 350
golden goose slide
curry 8
yeezy 350 v2
jordan 1 low
a bathing ape
hermes belts
golden goose sneakers
kyrie irving shoes