Microsoft® Excel® based database addin

 
+ Reply to Thread
Results 1 to 3 of 3
  1. 11-18-2008 07:15 PM #1
    CmputrAce
    CmputrAce is offline Junior Member
    Join Date
    Nov 2008
    Posts
    2

    Default Oracle Schema - Allow user to specify (limit to)

    First, thank you for an EXCELLENT tool!

    I have a database that I am connecting to that has seven schemas, each of which has over 2,000 tables and 99 views. When I connect to the database with SQLExcel, it takes quite a while to load all the objects from all the schemas, then I have to collapse all the schemas that I am not interested in to get to the one that I am.

    Question: Is there any way to limit which schemas SqlExcel loads, either in the connection string or some parameter in SQLExcel? I desperately need this...

    Thank you,
    Jim
    Reply With Quote Reply With Quote  
  2. 11-20-2008 01:40 AM #2
    admin's Avatar
    admin
    admin is offline Administrator
    Join Date
    Apr 2008
    Location
    Dublin, NYC
    Posts
    333
    Blog Entries
    1

    Default Re:Oracle Schema - Allow user to specify (limit to)

    hi

    Thanks for the kind words..

    Sorry for the delay in replying.. Hope you managed to work around this issue..

    On the addin side, there is no parameter or option to change (connection is built using the data links component and the addin just works with this connection object).

    On the connection string side, there may be a way to limit the connection to a specific schema.. I know the same issue came up for someone here that had the same problem with DB2 and he managed to work around it I think by setting a default schema for the connection.

    I am not sure if this same connection parameter exists with Oracle but will take a look at this over the weekend.
    I found this article
    http://forums.oracle.com/forums/thre...hreadID=321982
    which seems to suggest it is not possible but maybe there is a way to do this. need to look a bit more..

    Please let me know which data provider you are using to connect.Sorry cant be more helpful there..

    Also, I know this is a problem with the addin and will be working to get a fix in for this type of situation.. Just need to get some time to do the work.
    have a nice evening
    Al
    SQL Drill Support
    www.sqldrill.com
    Reply With Quote Reply With Quote  
  3. 11-20-2008 02:11 PM #3
    CmputrAce
    CmputrAce is offline Junior Member
    Join Date
    Nov 2008
    Posts
    2

    Default Re:Oracle Schema - Allow user to specify (limit to

    Thank you for the quick response!

    I understand the issues about getting time to get to the coding. If you need any help there, let me know.

    Jim
    Reply With Quote Reply With Quote  
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules