Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 12:30 PM

    Can you please try datastore aliases, under datastore advanced for new configuration.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 01:22 PM

    Hi Guy,

    Ask your DBA how he gave you the right on the tables:

    1) If you have the right to use the tables you should see them when importing = double clicking on the DataStore.

    e.g. I gave my user rights to select table scott.bonus:

    SQL> GRANT SELECT ON SCOTT.BONUS TO NOR;

    Grant succeeded.

    And can see that table in the NOR user data store.

    2) Search for a table name you know in the DataStore to import.

    Regards

    Norbert

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2012 at 02:26 AM

    Hi Guy,

    Please request your DBA to provide the grant for all the schemas and its tables(That should be the user id you are connecting through BODS). So that you can import the required tables in the data store.

    Regards

    Nag

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.