Catégorie
Version du produit
Rubrique
Sous-rubrique
La langue
How to backup, transfer, restore the SQL Navigator user settings profile? What if 'Cancel' was hit? (4273082)
How to backup, transfer, restore the SQL Navigator user settings profile i.e. from one SQL Navigator to another or from one PC to another or from an old computer to a new computer? ... How to import settings when the 'Cancel' button is accidentally clicked during the initial startup of a SQL Navigator installation?
Package specification in SQL Navigator still shows as checked out with Subversion (SVN) (4375635)
When checking out a package body, a lock is also placed on corresponding package specification although only the body was requested. ... Within SQL Navigator repository only the body is checked out.
Unable to remove time info from a date field in the editor. (4375558)
Unable to remove time info from a date field in the editor. ... Select a table record with a date containing a time information. ... <br>2. ... Edit the date and change just the time to 00:00:00, after commit the date and time is not altered.
Running a user_scheduler_jobs query freezes SQL Navigator for minutes (4375436)
When running the following query, SQL Navigator v8.0 freezes for several minutes. ... The query returns ok, but the application appears to hang once it is returned<br><br>SELECT *<br>FROM user_scheduler_jobs a<br>ORDER BY a.job_action; Please uninstall and reinstall SQL Navigator to resolve the issue of hanging after running a query.
Order by statement is not retained when you choose another editor tab, and go back to the original one (4375174)
Order by statement is not retained when you choose another editor tab, and go back to the first one.<br><br>Steps to replicate:<br>1. ... In a new Editor tab (tab1) Run a select statement with order by asc on a column with a date<br>2.
SQL Navigator for Oracle Team Coding refresh issue in GUI (4375110)
When a user manually edits the Team Coding tables using a script, the objects are checked out or checked in. ... The Team Coding in the GUI indicates that the object is Read-Only, and therefore, you cannot edit the object in the editor.<br><br>The object can only be edited when you open a new connection to the database.
Error 'Name length exceeds 30 characters' when searching code with a long name (4374952)
In SQL Navigator 8.0, when you have a long procedure name such as:<br><br>CREATE OR REPLACE<br>procedure thisisaprocedurewithaverylongnameandwillgiveanerror as<br>begin<br>--test<br>null;<br>end;<br>/<br><br>Then:<br><br>- Go to Search | Code Search | What tab and type part of the procedure name<br>- Go to the 'Where' tab and choose All Schemas like %<br>- Click Search<br><br>The error 'Name length exceeds 30 characters' appears.<br><br>This issue only happens when All Schemas is selected. It is fine when you run this on the User schema WORKAROUND:<br>None.<br><br>STATUS:<br>Waiting for fix in a future release of SQL Navigator for Oracle SQLNAV-2459
When View | Preferences is accessed an error 'Not Connected' is shown (4374988)
This is newly implemented in Navigator 8.0.
Unable to update record within grid interface (F2) when Oracle tables has double quotes (4374755)
It's not possible to update a record within the data grid (F2) when an Oracle table has double quotes. ... If using a table with double quotes fields in a query, and updating a record within the grid, the data is not updated.<br><br>The message 'There are pending changes....Do you want to save changes' appears.
After using Find and Replace, text is appended to highlighted selection, rather than replacing it (4373723)
If you have used the Find and Replace menu in the Editor of SQL Navigator, and a word is still highlighted to replace, and you press Esc to close the Find and Replace windows, the text is still highlighted black in the Editor, like the Find and Replace window is still open in the background.
Existing packages code show an extra line in SQL Navigator 8.0 (4373760)
Opening existing package codes in SQL Navigator 8.0 shows extra lines. ... Because of a last-minute defect SQLNAV-2453, the SQL Navigator 8.0 was retired from the website for regression testing. ... If a user downloaded SQL Navigator before 10/24/2023, it's required to download the new SQL Navigator build.
What's New in SQL Navigator 8.0? (4373518)
Support of the most recent SQL Editor formatting and parsing syntax capabilities Resolved issues: ... SQL Navigator encounters slow loading times when attempting to open large objects containing more than 10,000 lines from a database.
Very slow loading time for PL/SQL packages. (4373091)
With a PL/SQL package of approximately 16000 lines, it takes nearly 20 seconds to load for SQL Navigator 7.6.
How does Toad and SQL Navigator access the tnsnames.ora file and info? How do you change/specify (4316742)
How does Toad and SQL Navigator access the tnsnames.ora file and info? ... How do you change/specify the TNSnames.ora file location? ... In the TNSnames Editor in Toad, it automatically picks up the tnsnames.ora file, but I want to redirect to a different file.
Getting errors when connecting with an Oracle Instant Client (4310962)
The following errors may occur when using Oracle Instant Client. ... 2. The are no database connections to choose from the drop down list. ... 3. ORA-12705 Cannot access NLS data files or invalid environment specified.
Can't login to Toad. What is the Toad password? Where do I get my login credentials? What is my user name and password? (4226333)
Cannot or unable to login. ... Where do I get my login credentials? ... What is my username and password? ... The account is locked so it needs to be unlocked and the password reset. ... There is a prompt that the password has expired, and to reset, the old password is needed, but what is the old password?
How do I verify the magnitude of my licensing keys? (4232458)
How do I verify the magnitude of my licensing keys? ... Please contact license@quest.com and provide any license key/site message information that you have and a representative from the licensing group will contact you shortly.
SQL Navigator license key search (4265012)
The NavKeyScan.exe utility can scan a network and find SQL Navigator installs on every machine. ... Here how it works, it will search for qsauthorize12.key: ... The person who runs the utility must have Admin right to all machines which needs to be scanned, ideally it will run by customers' MIS Admin people.
Using SVN and TortoiseSVN with SQL Navigator. (4270224)
User wants to use SVN and TortoiseSVN as version control with SQL Navigator. ... Please review the attached video tutorial in the following order. ... To play unzip the files first. ... The first movie "Using SVN with SQL Navigator" demonstrates SQL Navigator using SVN for the version control system (checking out and checking in a procedure).
Extract DDLs from packages or Compile are missing in the schema browser (4259899)
In the Schema Browser, the compile objects and extract ddl options are missing for packages. ... These options are normally available on the pop up menu upon right click on the package name. ... The icons for these options are also disabled in the toolbar .
SQL Optimizer Compare Scenarios not showing all the alternative SQL statements (4305551)
User runs SQL Optimizer on a query and it returns many alternative SQL statements listed in the SQL Details window. ... However after clicking on Optimize or Execute, the user will be taken into the Compare Scenarios window.
View Differences. The 'Switch Sides', 'Copy to Right' (and Left), 'Delete Left Text' (and Right), and 'Undo' icons are grayed out or unavailable. (4308243)
They are not working.
Allowing users to view database objects from other users without granting the Select_Catalog_Role (4214674)
When attempting to grant access to other users objects without granting the Select_Catalog_Role or Select_Any_Table privilege. ... 1. Create a role called QUEST_NAV_VIEWS ... 2. Login as sys and grant the following view to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_ALL_TABLES to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_ERRORS to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_OBJECTS to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_OBJECT_TABLES to QUEST_NAV_VIEWS grant SELECT on VIEW SYS.DBA_SOURCE to QUEST_NAV_VIEWS
Dbms_output window text lines are truncated (4241716)
Dbms_output window text lines are truncated at some rather random looking line length. ... It's not truncated at a certain number of characters as the last character is actually sliced in half. ... It's not sliced at the width of the window either.
How to reset or restore SQL Navigator to the factory default settings and options? (4287291)
How to reset or restore the SQL Navigator Preferences to the default options or settings? ... Go to View menu | Preferences | click on the "Reset" button | and then click Yes on the Confirmation pop-up box.
Nouvelle association de produits
- Outils libre-service
- Base de connaissances
- Notifications et alertes
- Support produits
- Téléchargements de logiciels
- Documentation technique
- Forums utilisateurs
- Didacticiels vidéo
- Flux RSS
- Nous contacter
- Support Technique
- Afficher tout