Re: ORA-14109: partition-extended object names may only be used with tables
Date: Tue, 4 Nov 2008 17:33:58 +0100
Message-ID: <49107970$0$14097$426a74cc@news.free.fr>
"Narokman" <naerok1999_at_yahoo.com> a �crit dans le message de news:
6409b90d-1cb7-4f08-b652-1d8d21771c47_at_c2g2000pra.googlegroups.com...
| I'm a beginner in using partition in oracle tables.
| Below query returns ORA-14109. (I skipped on WHERE clause in below
| query because either way, it returns same error message.) I assure
| you tableC is a valid table name and partitionC is one of valid
| partitions of tableC.
|
| SELECT a.field1, b.field2, c.field3
| FROM tableA a, tableB b, tableC PARTITION (partitionC) c;
|
| What am I misssing?
| Your help would be greatly appreciated.
ORA-14109: partition-extended object names may only be used with tables *Cause: User attempted to use a partition-extended object name
with an object which is not a table. *Action: Avoid using partition-extended name syntax with objects
which are not tables
Regards
Michel
Received on Tue Nov 04 2008 - 10:33:58 CST