Select table in a query withough referencing the db scheme
751317Mar 2 2010 — edited Mar 2 2010Hi,
I converted my database from MySql to oracle using the 10g express edition for proof of concept before going into production and I have across with an issue with running my queries.
For example when I try the following query from the "Oracle SQl Developer" it comes back with error message that the table does not exist. SELECT * FROM myTable; whereas if I change the query to the following: SELECT * FROM myScheme.myTable; it works fine.
I am executing queries from java application with spring jdbc layer and it is very inconvenient to add new implementation layer to my application just because I can't reference the table without putting the scheme first.
An interesting test that I did was to create a new table without using the migration tool just to make sure it is not something that oracle does by default and it worked fine without having to have to append the scheme in front of the table.
Any help will be appreciated as I am very new to the oracle db world.
Thank you.