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.