Re: ORA-14109: partition-extended object names may only be used with tables

On Nov 4, 8:12 am, Narokman <naerok1..._at_yahoo.com> wrote:
> 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.

Your DDL to create these tables would be appreciated. We can't tell you what may be occurring if we can't recreated the environment you're trying to use.

David Fitzjarrell Received on Tue Nov 04 2008 - 08:20:35 CST