dbTalk Databases Forums  

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

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc ORA-14109: partition-extended object names may only be used withtables

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


Discuss ORA-14109: partition-extended object names may only be used withtables in the comp.databases.oracle.misc forum.



Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
Narokman
 
Posts: n/a

Default ORA-14109: partition-extended object names may only be used withtables - 11-04-2008 , 08:12 AM





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.

Reply With Quote
  #2  
Old   
ddf
 
Posts: n/a

Default Re: ORA-14109: partition-extended object names may only be used withtables - 11-04-2008 , 08:20 AM





On Nov 4, 8: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.
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


Reply With Quote
  #3  
Old   
ddf
 
Posts: n/a

Default Re: ORA-14109: partition-extended object names may only be used withtables - 11-04-2008 , 08:20 AM


On Nov 4, 8: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.
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


Reply With Quote
  #4  
Old   
ddf
 
Posts: n/a

Default Re: ORA-14109: partition-extended object names may only be used withtables - 11-04-2008 , 08:20 AM


On Nov 4, 8: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.
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


Reply With Quote
  #5  
Old   
ddf
 
Posts: n/a

Default Re: ORA-14109: partition-extended object names may only be used withtables - 11-04-2008 , 08:20 AM


On Nov 4, 8: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.
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


Reply With Quote
  #6  
Old   
Michel Cadot
 
Posts: n/a

Default Re: ORA-14109: partition-extended object names may only be used with tables - 11-04-2008 , 10:33 AM



"Narokman" <naerok1999 (AT) yahoo (DOT) com> a écrit dans le message de news:
6409b90d-1cb7-4f08-b652-1d8d21771c47...oglegroups.com...
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.
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




Reply With Quote
  #7  
Old   
Michel Cadot
 
Posts: n/a

Default Re: ORA-14109: partition-extended object names may only be used with tables - 11-04-2008 , 10:33 AM



"Narokman" <naerok1999 (AT) yahoo (DOT) com> a écrit dans le message de news:
6409b90d-1cb7-4f08-b652-1d8d21771c47...oglegroups.com...
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.
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




Reply With Quote
  #8  
Old   
Michel Cadot
 
Posts: n/a

Default Re: ORA-14109: partition-extended object names may only be used with tables - 11-04-2008 , 10:33 AM



"Narokman" <naerok1999 (AT) yahoo (DOT) com> a écrit dans le message de news:
6409b90d-1cb7-4f08-b652-1d8d21771c47...oglegroups.com...
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.
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




Reply With Quote
  #9  
Old   
Michel Cadot
 
Posts: n/a

Default Re: ORA-14109: partition-extended object names may only be used with tables - 11-04-2008 , 10:33 AM



"Narokman" <naerok1999 (AT) yahoo (DOT) com> a écrit dans le message de news:
6409b90d-1cb7-4f08-b652-1d8d21771c47...oglegroups.com...
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.
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




Reply With Quote
  #10  
Old   
joel garry
 
Posts: n/a

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


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!


Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top