Friday, December 15, 2006

Renaming table when MV log is associated

Recently, I faced problem in renaming a table. The table had a materialized view log associated with it and I wanted to move the older version of the table and place a new version of the same instead.

But I was getting following error while renaming the old table:

ORA-26563: renaming this table is not allowed

One of the reasons of getting this error is, the table is used in a materialized view and a materialized view log is associated with the table to track the data changes.

Following are the steps need to be taken while renaming such tables:

1. Begin table organization to rename old table to bkup table
EXEC DBMS_MVIEW.BEGIN_TABLE_REORGANIZATION(USER,'OLD_TAB');

2. Rename old table to bkup table

RENAME OLD_TAB TO NEW_BKUP;

3. Rename new table to original table name

RENAME NEW_TAB TO OLD_TAB;

4. End table organization after renaming new table to original table name

EXEC DBMS_MVIEW.END_TABLE_REORGANIZATION (USER,'OLD_TAB');

19 comments:

Ravi Krishnan said...

Thanks for the info. Helped me a lot

Anonymous said...

Etwas bei mir begeben sich die persönlichen Mitteilungen nicht, der Fehler welche jenes viagra cialis generika [url=http//t7-isis.org]cialis preis ?sterreich[/url]

Anonymous said...

Hi,

I am regular visitor of this website[url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips].[/url]You have really contiributed very good info here justoracle.blogspot.com. I am sure due to busy scedules we really do not get time to care about our health. In plain english I must warn you that, you are not serious about your health. Recent Research shows that almost 80% of all United States grownups are either obese or weighty[url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips].[/url] So if you're one of these individuals, you're not alone. Its true that we all can't be like Brad Pitt, Angelina Jolie, Megan Fox, and have sexy and perfect six pack abs. Now the question is how you are planning to have quick weight loss? [url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips]Quick weight loss[/url] is not like piece of cake. You need to improve some of you daily habbits to achive weight loss in short span of time.

About me: I am author of [url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips]Quick weight loss tips[/url]. I am also mentor who can help you lose weight quickly. If you do not want to go under hard training program than you may also try [url=http://www.weightrapidloss.com/acai-berry-for-quick-weight-loss]Acai Berry[/url] or [url=http://www.weightrapidloss.com/colon-cleanse-for-weight-loss]Colon Cleansing[/url] for quick weight loss.

Anonymous said...

how to unlock iphone
iphone unlock

unlock iphone how to unlock iphone unlock iphone
how to unlock iphone

unlock iphone how to unlock iphone [url=http://ounlockiphone.com]unlock iphone [/url] unlock iphone

Anonymous said...

strum ruger dating http://loveepicentre.com/success_stories.php list of top dating sites

Anonymous said...

[url=http://loveepicentre.com/advice.php][img]http://loveepicentre.com/uploades/photos/1.jpg[/img][/url]
speed dating tucson arizona [url=http://loveepicentre.com/testimonials.php]free new online dating sites[/url] dating in tampa
relative dating atmossphere [url=http://loveepicentre.com/testimonials.php]dating the earth through the bible[/url] online dating free single mirrage sites
sacramento dating service [url=http://loveepicentre.com/map.php]free herpes dating site canada[/url] speed dating ottawa

Anonymous said...

permanent ros ebook reviews http://audiobookscollection.co.uk/Technologies-for-E-Learning-and-Digital-Entertainment-Third-International-Conference-Edutainment-2008-Nanjing-China-June-25-27-2008-Proceedings-Applications-incl-Internet-Web-and-HCI/p209803/ jon pertwee ebook [url=http://audiobookscollection.co.uk/it/Adobe-After-Effects-6-5-Studio-Techniques/p104745/]free harry potter ebook[/url] ebook rotique

Anonymous said...

Hello. And Bye. Thank you very much.

Anonymous said...

Hello. And Bye. Thank you very much.

Anonymous said...

best ocr software free http://buysoftwareonline.co.uk/fr/category-100-106/Logiciel-de-serveur?page=2 acdsee software for sale [url=http://buysoftwareonline.co.uk/es/category-100-107/Programaci-n-y-elaboraci-n]metatrader 4 software[/url] websphere software
[url=http://buysoftwareonline.co.uk/es/product-23743/Adobe-Contribute-CS4-Mac]Adobe Contribute CS4 [Mac] - Cheap Legal OEM Software, Software Sale, Download OEM[/url] windows live messenger software
[url=http://buysoftwareonline.co.uk/it/product-37274/Tansee-iPod-Transfer-Photo-3-2][img]http://buyoem.co.uk/image/4.gif[/img][/url]

Anonymous said...

[url=http://onlinemedistore.com/products/kamagra.htm][img]http://onlinemedistore.com/3.jpg[/img][/url]
connecticut pharmacy law http://onlinemedistore.com/products/prednisolone.htm juarez mexico pharmacy location [url=http://onlinemedistore.com/products/viagrx.htm]indiana pharmacy tech testing[/url]
mexican pharmacy thyroid http://onlinemedistore.com/products/adalat.htm westlab pharmacy [url=http://onlinemedistore.com/products/lotensin.htm]lotensin[/url]
pharmacy technician employmnent rate new jersey http://onlinemedistore.com/products/avapro.htm pharmacy tech exam [url=http://onlinemedistore.com/products/arimidex.htm]pharmacy tropicale[/url]
heb pharmacy san antonio http://onlinemedistore.com/products/kamasutra-ribbed-condoms.htm softtabs online pharmacy [url=http://onlinemedistore.com/products/strattera.htm]strattera[/url]

Anonymous said...

[url=http://certifiedpharmacy.co.uk/products/paroxetine.htm][img]http://onlinemedistore.com/9.jpg[/img][/url]
olden pharmacy nj http://certifiedpharmacy.co.uk/categories/hypnotherapy.htm pharmacy tech nationwide [url=http://certifiedpharmacy.co.uk/categories/birth-control.htm]pharmacy vacancy in sao tome and principe[/url]
walmart pharmacy gulf shores al http://certifiedpharmacy.co.uk/products/procardia.htm aetna pharmacy provider application [url=http://certifiedpharmacy.co.uk/products/horny-goat-weed.htm]horny goat weed[/url]
pharmacy technician online training http://certifiedpharmacy.co.uk/products/compazine.htm soma online pharmacy [url=http://certifiedpharmacy.co.uk/products/cipro.htm]cvs pharmacy in budd lake new jersey[/url]
online pharmacy pay pal http://certifiedpharmacy.co.uk/products/allopurinol.htm pharmacy fall night in coralville iowa [url=http://certifiedpharmacy.co.uk/products/vermox.htm]vermox[/url]

Anonymous said...

With color B, working in Japan and dressed
very formally, it would be nice if. The book is called Talon and it's spinning out of the gate, with plans for more robust experiences in the upcoming months. That said, the antennas still camsex comprise the rim of the device, exactly where your fingers likely aren't.
3 million Americans worked as retail salespeople as of last May,
according to the American people had their way, big
banks may not stay so big much longer.

Also visit my web page :: sex chat

Anonymous said...

[url=http://englandpharmacy.co.uk/products/phenergan.htm][img]http://onlinemedistore.com/2.jpg[/img][/url]
va board of pharmacy http://englandpharmacy.co.uk/products/lysexl.htm evolution of hospital pharmacy [url=http://englandpharmacy.co.uk/catalogue/j.htm]pondimin from mexican online pharmacy[/url]
best company to get pharmacy technician certification http://englandpharmacy.co.uk/products/accutane.htm mrt online pharmacy [url=http://englandpharmacy.co.uk/products/sinemet.htm]sinemet[/url]
pharmacy cialis http://englandpharmacy.co.uk/products/zovirax.htm pharmacy powerpak [url=http://englandpharmacy.co.uk/products/clomid.htm]national pharmacy technician association[/url]
employment costco pharmacy http://englandpharmacy.co.uk/products/torsemide.htm canadian pharmacy provigil [url=http://englandpharmacy.co.uk/products/prinivil.htm]prinivil[/url]

Anonymous said...

widow dating son's friend bruce bart tattoo myspace filipio dating
speed dating spreadsheet http://freeinternetdating.info/romance/free-online-romance-books-stories lacy schwimmer dating
book on dating in your 30 online dating hasty generalization dating show 1999

Anonymous said...

If you feel that you have to clear your mind of them while you
are at work. 12 scRnd 1 Right side: With MC, ch 2,
4 sc in same sp, 2 dc in same st, skip next st, sc in next sc, 2 sc in
next 2 fleshlight sc, ch 1, turn.
The first thing that grabs your attention is how lifelike the fleshlight actually feels and
responds very similar to what you like.

Anonymous said...

So, start today and rid yourself of those annoying and unsightly growth.
Once you do, you will know which type of remover to buy that will not irritate your skin.
The brown-slatted background in the image above really isn't part of the technique I was trying to demonstrate here.

Here is my blog :: painful skin tags

Anonymous said...

Another available treatment option that can be done at home without a prescription is a topical ointment.
If you carefully read all of the directions on the package, you
can freeze off your skin tags without feeling any pain
and they'll be quickly eliminated. The brown-slatted background in the image above really isn't part
of the technique I was trying to demonstrate here.



Also visit my site :: skin tags Baking soda (Cdinterface.sourceforge.net)

Anonymous said...

Howdy I am so glad I found your blog, I really found you by mistake,
while I was browsing on Aol for something else, Regardless I am here now and would just like to say thanks
a lot for a incredible post and a all round
exciting blog (I also love the theme/design), I don't have time to read through it all at the moment but I have saved it and also added in your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the superb job.

My webpage - best allergy medicine for ragweed