0 Replies Latest reply on Jan 18, 2016 4:53 AM by user13166858

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

    user13166858

      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