I'm trying to re-engineer a schema. I got through the process for a postgres database and it works like a charm. Create the datamap, configure the connection, refresh the db schema, and up pops the tables from the database, just as you would expect.
I follow up with a similar task only this time trying to connect to an Oracle DB and the process seems to be working up to the point where the database schema should reflect the tables in the database, and there nothing happens. The "Refresh DB Schema" button stays dim and inactive almost as if it was stuck trying to pull back the schema. Now this is a large db with a lot of tables and a lot of data in the tables (not that it should matter, but...). I've used the test button on the edit data source preferences and it responds with a successful connection mesg. I thought maybe it was just taking a long time, but i've waited 5 minutes and nothing happens. Is there anyway to increase the logging level on the modeler so that I can see what if anything is happening as it tries to load up the schemal from this oracle db? Tony