Skip to Content
0
Former Member
Nov 12, 2012 at 11:19 AM

Added Datastore but unable to import tables since the tables are in a different Schema

637 Views

My company provided me the oracle database details with username/ password and TNS details etc.

Now i am able to create datastore successfully, but unable to import the tables, reason it is in different schema below the same servicename.

Is there a possibility to choose the schema under teh database while importing tables into datastore.

Or my company should provide me other credetials which straiht away points to that schema where all tables are?

VIA SQL developer after i login to teh DB, i choose the schema T500, automatically i see all tables, i am able to query, but by default it shows my username within schema.. as soon as i pick T500 i shows all tables. that is via SQL developer or TOAD.

Thank you all for the helpful info.