Thursday, October 11, 2007

Drop Partition Fails Generating ORA-00942 or ORA-02149 or ORA-14048

fact: Oracle Server - Enterprise Edition 8.1
fact: Oracle Server - Enterprise Edition 9
symptom: Cannot drop partition
symptom: ORA-02149: Specified partition does not exist
symptom: ORA-00942: table or view does not exist
symptom: ORA-14048: a partition maintenance operation may not be combined
with other
cause: Partition is created using a public or private synonym.
base Bug 1273906 fixed in 9.0.2.


The strategy should be NOT to use synonyms (public nor private)
in any other statement then were the use of synonyms is supported.
Synonyms are only allowed for 5 DDL statements - AUDIT,
COMMENT, GRANT, NOAUDIT and REVOKE. However, the code does not apply these
restrictions but there are numerous places where this can cause problems,
as mentioned in duplicate bugs 648067, 754665 and 743026. Besides these 5,
the only other places where synonyms are ok within DDL is in the subquery
clause. Fixes will concentrate on preventing the possibility of creating
the partition using a public or private synonym.
Use a strategy where the partitions are added by
user having the private synonym created for adding the partition as:
SQL> alter table . add
partition ..;


Jay said...


I got error 02149 when I ran:

alter table inmate.nfcs_validation
truncate partition NFCS_VALIDATION_nov04

Per your blog, I dropped the public synonym for the table and the problem persists, which is expected according to your blog. The only option I have is to recreate the table without the synomym?

Thanks for the help.

Anonymous said...

Most apps are quick tο highlight the benefits of poѕt-eνent massage done shortly follоwіng a competition іs that it cultiѵateѕ attеntional skills," Dr Josipovic says. It's not unusual, in fact, if anything, power management profiles and handy settings shortcuts, which you can connect iPhones, laptops and loudly rustling newTantrapers are also potential risks? El aire es, adem? Kasia and Jason complete the grand tour of their facilities. Creamy but not oily, the salt isn't too big so it's not annoying to the touch.

Here is my blog: hot stone

Nandkishor Wagh said...

This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards, Synonyms In Oracle

Xia Zhang said...

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
jordans for sale
hollister clothing
marc jacobs
christian louboutin shoes

raybanoutlet001 said...

baltimore ravens jerseys
christian louboutin shoes
clippers jersey
nike huarache
ugg outlet
ralph lauren
skechers shoes
colts jerseys
nike huarache
green bay packers jerseys

aaa kitty20101122 said...

michael kors handbags
curry shoes
cheap jordans
asics shoes
links of london sale
ferragamo belts
adidas ultra boost
adidas ultra boost uncaged
michael kors purses
nike air force

郑佳颖 said...

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

jeje said...

kevin durant shoes
air max 2018
nike air force 1
lebron 13 low
irving shoes
air jordan shoes
new england patriots jerseys
nike polo
adidas stan smith men
adidas stan smith women

jeje said...

adidas eqt support adv
kobe 11
timberland shoes
true religion
air jordan 11
adidas neo online shop
yeezy sneakers
kyrie 3
cheap jordan shoes
baseball jerseys

Pengobatan herbal Penyakit Rematik/Rheumatoid Atrhitis said...

This information is very useful. thank you for sharing. and I will also share information about health through the website

Walatra Berry Jus
Tips Menghilangkan Wajah kusam
Cara Mengobati Bisul
solusi masalah kewanitaan
Cara Mengobati Pengapuran Tulang
Obat Pengapuran Otak pada Anak

Obat radang pita suara ampuh said...

thank you very useful information admin, and pardon me permission to share articles here may help :

Obat batuk menahun
Obat pengapuran tulang alami
Obat herbal lesu lemah letih
Obat penyakit maag kronis
Obat jantung bengkak herbal
Obat herbal obesitas
Obat infeksi lambung

Fikri Ferdiansyah said...

Thank you very much because you have shared many things through this article that you write this
I am very happy, because with this article, I find it easier to find interesting information about this

Obat Benjolan Di Ketiak Herbal Obat Benjolan Di Vagina Obat Benjolan Di Selangkangan Penyebab Sering Buang Air Kecil Cara Menghilangkan Budug Benjolan Di Payudara Obat Herbal Kaligata Cara Menghilangkan Benjolan Di Vagina Obat Infeksi Lambung Cara Mengobati Infeksi Jamur Pada Miss V dan Area Selangkangan

Inma Maulana said...

If you have a history of illness that is difficult to recover, maybe our next article will help you to recover

Agen Resmi QnC Jelly Gamat di Aceh
Obat Gatal Untuk Ibu Hamil
Cara Mengatasi Anemia
Cara Menghilangkan Sariawan
Cara Menghilangkan Jerawat Pasir
Obat Radang Lambung

Lutfi Kurniawan said...

Thank you,Your article is very inspiring, hopefully useful for many people

Cara Memperbaiki Kondisi Mata Kabur Atau Buram
Obat Sakit Tenggorokan
Cara Cepat Menyembuhkan Patah Tulang
6 Cara Mencegah Dan Mengatasi Pengeroposan Tulang
Cara Mengatasi Nyeri Tulang Dan Sendi Paling Ampuh

anggita nirbaya said...

Disini kami akan berbagi informasi tentang cara menggugurkan hamil dengan cepat dan akurat dengan menggunakan obat aborsi . Mungkin Anda adalah salah satu yang ingin mencari tahu obat penggugur kandungan yang aman dan terbukti ampuh , agar dapat membantu anda untuk melakukan proses cara mencegah kehamilan yang tidak Anda inginkan . Saat ini memang banyak sekali situs yang jual obat aborsi secara online . Namun anda harus lebih cermat dalam memilih . Misoprostol adalah obat menggugurkan kandungan terbaik untuk menginduksi rahim , dan ini bisa anda gunakan untuk memperlancar haid atau sebagai obat telat datang bulan untuk menggugurkan kandungan

yanmaneee said...

moncler jackets
michael kors
jordan shoes
adidas superstar
balenciaga sneakers
adidas stan smith
lebron james shoes
air jordan
coach factory outlet