ORA-14109: partition-extended object names may only be used withtables

#11

On Nov 4, 6:12*am, Narokman <naerok1... (AT) yahoo (DOT) com> wrote:

Quote:

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';

jg
--
@home.com is bogus.
Vote early, and vote often!

#12

On Nov 4, 6:12*am, Narokman <naerok1... (AT) yahoo (DOT) com> wrote:

Quote:

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';

jg
--
@home.com is bogus.
Vote early, and vote often!

#13

On Nov 4, 6:12*am, Narokman <naerok1... (AT) yahoo (DOT) com> wrote:

Quote:

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';

jg
--
@home.com is bogus.
Vote early, and vote often!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ORA-14109: partition-extended object names may only be used withtables

comp.databases.oracle.misc comp.databases.oracle.misc

Re: ORA-14109: partition-extended object names may only be used withtables - 11-04-2008 , 12:19 PM

Re: ORA-14109: partition-extended object names may only be used withtables - 11-04-2008 , 12:19 PM

Re: ORA-14109: partition-extended object names may only be used withtables - 11-04-2008 , 12:19 PM