[This topic is migrated from our old forums. The original author name has been removed]
- As mentioned in another post it would be nice to have an option to open an individual sql editor for each new connection.
- Add Database Links and Scheduled Jobs in the listing of objects for each schema.
- Scrollable result set(past the max rows).
- The ability to alter Tablespaces and datafiles, not just view them.
- Provide a tab under the DBA Views->Storage->Tablespaces that shows the objects in that tablespace.
- Under DBA Views->Locks provide blocking lock information. For instance is the session blocking another session and if so which one.
- Under DBA Views->Locks provide the action to kill a session just as you can under the Sessions View.
- Under DBA Views->Storage->Tablespaces provide the ability to create and modify tablespaces. For example resizing and adding data files.
- It would be nice if the sql bookmarks were stored in a separate XML file. This way I could create a list of standard Oracle related bookmarks and provide them to my coworkers or other DbVis users.
Nathan,
> I finally got around to reading the documentation (afterseveral months of using DbVis). I
> was pleasantly surprised when I sawthe Plug-in Framework documentation. I am very
> excited about thisfunctionality. I would like to add all the features that I posted underthe
> Feature Request forum. One issue that I have is that there are noTypes defined for:
>
> Database Links
> Public Database Links
> Jobs
>
> Would it be possible for youto add these in the next release?
We'll add these as:
DatabaseLinks
DatabaseLink
PublicDatabaseLinks
PublicDatabaseLink
Jobs
Job
> Also can you please describe what the variable "#cp.SystemTablePrefix" does? I didn't see
> it described in the documentation. Also what are the other commands associated with #cp. > and #dm? Are these methods in a class somewhere?
#cp = ConnectionProperty
The SystemTablePrefix is the connection property for the visual connection property: Oracle->Objects Tree->System Views Prefix
The name of every connection property that exist are not documented. You do however find them in the dbvis.xml file (in the ... section).
#dp = Driver Property. These are listed in the Connection Properties->Driver Properties list for the actual database connection.
#dm = DatabaseMetaData class. Here you may use any accessor method available in the java.sql.DatabaseMetaData class.
> Also with conditional processing I want to do something along the following lines:
>
>
> but it doesn't seem to work. Can I use set variables in an If conditional statement?
Just so you know that conditions are processed at load of the profile and never once the profile is loaded. This simply mean that once the profile has been loaded you cannot use conditions to control that the content in for example the tree should be different for one specific schema compared to another i.e. one user should see 4 sub objects while another should see 10.
Read more in:
http://www.minq.se/products/dbvis/doc/main/doc/ug/databaseProfile/databaseProfile.html#mozTocId715316
Regards
Roger
a
anonymous
said
almost 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: A list of Oracle related requests...
You mentioned a dbvis.xml file. Where is the file located? I can't find it.
Thanks,
Nathan
Roger Bjärevall
said
almost 17 years ago
[This reply is migrated from our old forums.]
Re: A list of Oracle related requests...
Nathan,
Sorry missed that. Here's the location:
Windows:
[b]C:\Documents and Settings\\.dbvis\config\dbvis.xml[/b]
Linux/UNIX:
[b]/home//.dbvis/config/dbvis.xml[/b]
Mac OS X:
[b]/Users//.dbvis/config/dbvis.xml[/b]
Regards
Roger
a
anonymous
said
almost 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: A list of Oracle related requests...
I found the file. Thanks.
Can you provide a list of the Icon types?
I have almost completed the Database Link Functionality. It allows a user to:
View
Create
Drop
Test
database links. Are you interested in seeing what I came up with? It would be nice to have a separate forum that users could post there mods to so that there isn't any duplication of efforts.
Thanks,
Nathan
a
anonymous
said
almost 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: A list of Oracle related requests...
Nathan,
Yes, I am interested! Maybe you can post it in this thread?
Thanks,
Chris
a
anonymous
said
almost 17 years ago
[This reply is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Re: A list of Oracle related requests...
I copied and pasted the relevant entries for dblinks into this text file. You will need to copy and paste them from this file to your oracle.xml file. I have started creating the entries for Jobs. Jobs are taking some time because of the complication of creating a job. After that I will work on resizing data files. Also creating tablespaces needs to be altered so that you can mark files to autoextend at creation of the tablespace.
Let me know what you think.
Nathan
a
anonymous
said
almost 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: A list of Oracle related requests...
Great work, thanks!
I have not yet used the Actions myself, but I'm sure I will soon!
Please let us others know when you added more stuff! If you upload the whole profile next time, it would be easier for me to merge it into my own one.
Cheers, Chris
a
anonymous
said
almost 17 years ago
[This reply is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Re: A list of Oracle related requests...
Chris,
I just found a slight issue with the dblinks. I will re-upload the whole file. The only change is with the "oracle.getDatabaseLinks" command. The old SQL would display USERAs dblinks in USERBs schema. This fixes it.
Nathan
a
anonymous
said
almost 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: A list of Oracle related requests...
Thanks Nathan!
And I noticed that I placed the GroupNode for the tree structure in the wrong place (top instead of within the schema)... Silly me... Works like a charm now!
Roger Bjärevall
said
almost 17 years ago
[This reply is migrated from our old forums.]
Re: A list of Oracle related requests...
Nathan,
A new forum has now been setup for Database Profiles.
I have also moved some related threads to it.
Regards
Roger
anonymous
- Add Database Links and Scheduled Jobs in the listing of objects for each schema.
- Scrollable result set(past the max rows).
- The ability to alter Tablespaces and datafiles, not just view them.
- Provide a tab under the DBA Views->Storage->Tablespaces that shows the objects in that tablespace.
- Under DBA Views->Locks provide blocking lock information. For instance is the session blocking another session and if so which one.
- Under DBA Views->Locks provide the action to kill a session just as you can under the Sessions View.
- Under DBA Views->Storage->Tablespaces provide the ability to create and modify tablespaces. For example resizing and adding data files.
- It would be nice if the sql bookmarks were stored in a separate XML file. This way I could create a list of standard Oracle related bookmarks and provide them to my coworkers or other DbVis users.
Thanks
Nathan