Posted: Tue Nov 29, 2011 9:31 pm Post subject: Can not insert records in Oracle
I am copying data from oracle to MySQL and from MySql to Oracle.
From Oracle to My SQL works perfect but from MySQL to Oracle it does not work. I get error ORA-00942. This errors says that the table does no exist or that the user does not have authorizations. Well the table exists and I am trying with the dba user.
I have even try from oracle to oracle and just does not work. I got the same error.
My version of Apatar is 1.12.23
Oracle 10.2.02
Linux 2.4
Posted: Wed Nov 30, 2011 12:53 pm Post subject: Re: Can not insert records in Oracle
Patricio wrote:
I am copying data from oracle to MySQL and from MySql to Oracle.
From Oracle to My SQL works perfect but from MySQL to Oracle it does not work. I get error ORA-00942. This errors says that the table does no exist or that the user does not have authorizations. Well the table exists and I am trying with the dba user.
I have even try from oracle to oracle and just does not work. I got the same error.
My version of Apatar is 1.12.23
Oracle 10.2.02
Linux 2.4
Any help will be appreciated
Hello,
Try to write the name of scheme in Oracle connector in SQL query. _________________ Regards,
Sergei
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
