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

From: joel garry <>
Date: Tue, 4 Nov 2008 10:19:23 -0800 (PST)
Message-ID: <>

On Nov 4, 6:12 am, Narokman <> 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.

Wild guess: You have a view named the the same as the table.

select object_type from all_objects where object_name = 'TABLEA';


-- is bogus.
Vote early, and vote often!
Received on Tue Nov 04 2008 - 12:19:23 CST

Original text of this message