ORA-14109: partition-extended object names may only be used with tables
From: Narokman <naerok1999_at_yahoo.com>
Date: Tue, 4 Nov 2008 06:12:00 -0800 (PST)
Message-ID: <6409b90d-1cb7-4f08-b652-1d8d21771c47@c2g2000pra.googlegroups.com>
Date: Tue, 4 Nov 2008 06:12:00 -0800 (PST)
Message-ID: <6409b90d-1cb7-4f08-b652-1d8d21771c47@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.
Received on Tue Nov 04 2008 - 08:12:00 CST