Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

got error massage "ORA-00942" for creating table with select statement from multiple DB

user13166858Jan 17 2016 — edited Jan 18 2016

Hi All,

I don't know why I always got error massage "ORA-00942" while passing through the following query to Oracle via ODBC

create table table_AB as(

  select

     Customer_ID,

     Customer_Name,

     Order_Number,

     Order_Date

from

     Customer_Table

     left join Order_table@Order_DB on Order_table.customer_id = Customer_table.customer_id

);

Note: both database are linked at the server side. However, I am using a third party BI tools to while executing the query and that BI tool is connect to the DB that stored the Customer_Table via ODBC.

Both table is available from both database.

Thanks a lot

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 14 2016
Added on Jan 17 2016
0 comments
317 views