Configuration; They way I work with Oracle

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Posts: 6
Joined: Mon 14 Apr 2008 13:58

Configuration; They way I work with Oracle

Post by DanielLanz » Tue 23 Aug 2011 07:16

I always work whithin a schema. [1 Schema = 1 Project] I do develop different Projects for different customers in one oracle-instance. So I no not want to connect via a SYSDBA-login.
Therefore I need a possibility to disconnect.
I need multiple (different) connections
I need to know on which DBA-views need a "garnt select" for a fully functional Database explorer
I do not want the schema prefix in none of the SQL presentations
Please help me, to configure dbForge to achive this.

Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Post by Alexz » Tue 23 Aug 2011 09:10

To work comfortably with different schemas and connections in your case, you should switch off the "Show All Objects" option in the connection properties dialog. In this case for every connection that you have (for different customers) you will see only the objects from their schema in the Database Explorer.
By the way, if you switch off the "Show All Objects" option for a connection, Database Explorer won't try to access to DBA-views. So if you have any problems with this, feel free to contact us.

As for generating schema prefix, you can use the "Generate Schema Script" command from the context menu in the Database Explorer or from the Database (main menu), and switch off the "Prefix object names with a schema name" option on the "Script generation options" page (in the "General" category). Such option also exists in Schema Export and Project wizards.

Post Reply