Category
제품 버전
항목
하위 항목
Install Toad and Spotlight on a different computer (4377766)
From a licensing perspective, is it possible to install each tool on a different computer?" ... Yes, that is possible. ... Please run the Toad for Oracle installer in both computers and select the tools you want to install on each one of them.
Schema Compare option to use DBMS_REDEFINITION to modify column datatypes doesn't work unless the option "Add/Reorder columns with DBMS_REDEFINITION" is also checked. (4378269)
Schema Compare has an option to use DBMS_REDEFINITION to modify column datatypes. ... In some cases, this is the only way to change a column datatype (for example from VARCHAR2 to CLOB) without dropping and recreating the table.
Schema Browser 'Configure' menu item disappears after hiding all but one object types. (4378270)
If you configure the Schema Browser tabs to only show one tab / object type, if you right-click it again to add more database objects/tabs back again, the 'Configure' option does not show in the right-click menu, when you try to select more database object types.
How to transfer/copy workspaces from one machine to another? (4378154)
How to transfer/copy workspaces from one machine to another? ... In some cases workspaces may have references to external files (such as files opened in the Editor). ... If the files aren't there, the workspace will open, but you will need to re-save the files to a new location.
Compare Files doesn't reload when “Reload and Recompare Files” icon is clicked. (4377537)
1. Run schema compare against a pair of schemas that have at least one procedure/package difference ... 2. On the results tab, double-click a procedure that exists in both schemas but is different
How to define/change shortcuts in Toad for oracle? (4377942)
How to define/change shortcuts in Toad for oracle? ... Toad allows users to create their own shortcuts. ... Search for the desired category and assign the shortcut keys directly as per your convenience.
How to disable the Automatic Updates or the Toad Update message? How to silently deploy that setting? (4266101)
Each time Toad is launched, it displays the following message at the bottom right of the screen: ... A newer version of Toad is available to download. ... How to disable the Automatic Updates or the Toad Update message?
Checking for Existing Toad Product License Keys Without User Interaction (4378098)
Administrators or automated systems may need to verify the presence and validity of Toad product licenses without requiring user intervention. ... Manually checking each user's license information can be time-consuming and inefficient, especially in large deployments.
Toad for Oracle Licensing Across Windows and macOS (4378102)
<p>Users may assume a single Toad for Oracle license covers both Windows and macOS installations. ... This is incorrect and can lead to licensing compliance issues. ... The question arises whether an existing Windows Toad for Oracle license is also valid for use on macOS.</p> <p>A separate Toad for Oracle license is required for macOS.
Can I execute the proc in such a way that I can see results that tell me which steps are taking l (4364253)
I have a stored procedure that has several steps. ... Can I execute the proc in such a way that I can see results that tell me which steps are taking longer/ inefficient? ... I can put dbms_outputs everywhere, but I was hoping TOAD had some kind of trace/ diagnostic utility.
Error when connecting: "Cannot load OCI DLL: C:\app\<user>\product\11.2.0\client_1\oci.dll". (4225502)
Able to connect outside of Toad using existing Oracle Client, but when trying to connect within Toad, the following error is received: ... 1) 64-bit Oracle Client is being used with Toad for Oracle 32-bit.
TYPES do not show up in Schema Browser (4363604)
TYPES and declarations do not show up in Schema Browser's package source. ... Open an Editor window.<br>2. ... Enable the Navigator panel (if it's not already enabled). ... To do this, right click in Editor | Desktop | Navigator.
How to silently deploy additional products license key after Toad for Oracle is already installed? (4285484)
How to perform a silent deploy of additional products license key to all users after Toad for Oracle is already installed and already activated? ... To silently apply a license key for additional products to all users follow the steps below:
It is possible to drop a database object without logging in VCS (Git) in Toad v24 (4378018)
When using a drop statement with enabled team coding option, it is possible to drop a database object without logging in VCS. ... With the latest version of Toad configured with team coding and GIT , you cannot alter an object if not logged in VCS (as expected) but can drop a table.
What's New in Toad for Oracle 17.1? (4375923)
Use AI to explain SQL and PL/SQL with the new AIExplain preview feature. ... Learn more about AI and Toad at Toad World and Knowledge Base. ... Expanded IPv6 support ... Enable/Disable Automation Designer apps and actions
Get the error "ORA-00600 [Internal Error Codes]". (4336954)
It indicates the process has encountered a low-level unexpected condition, which typically means you’ve encountered an Oracle Database bug.<br><br>The impact can vary from just being an annoyance that shows up in your logs once in a while, to something major that brings the database down.<br><br>When an ORA-00600 error is logged it includes a list of arguments in square brackets.
Debugging on RAC raising error 'Unable RAC connection for database name, (used id=1)' (4367307)
While debugging on RAC an error is raised prompting "Unable to find RAC connection information for the database name, (used ID=1)" ... When debugging on RAC, Toad needs to make a 2nd connection to the same instance on the RAC cluster.
Toad For Oracle does Not close (4377825)
Toad cannot be closed. ... Something is blocking Toad to access to file online_resources.xml as the logs show: ... Info: Sending Request: GET (HTTP 1.1) to https://community-downloads.quest.com/toadsoft/ORACLE/VERSION/online_resources.xml
Unable to configure JDWP debugger - Error: “USER. does not exist or you do not have the necessary privileges…” (4375736)
The following error appears when attempting to step into Java Source while debugging (JDWP). 'Execution stopped' message followed by an access violation.<br><br>Bug: Error: “USER. does not exist or you do not have the necessary privileges…”<br><br>Toad for Oracle seems to be unable to resolve the java source specified.<br> Product Defect - TOR-8187 <p>WORKAROUND<br>NA<br><br>STATUS</p>
Export DDL option does not include the clause 'NOT SUBSTITUTABLE AT ALL LEVELS', when it was included in the create script (4375698)
The Export DDL option does not include the clause 'NOT SUBSTITUTABLE AT ALL LEVELS' for a table, when it was included in its create script originally.<br><br>For example, exporting an object table defined as:<br><br>CREATE TABLE TEST.test_T<br>NOT SUBSTITUTABLE AT ALL LEVELS<br>OBJECT ID PRIMARY KEY<br>/<br><br>Produces the following DDL script:<br><br>CREATE TABLE TEST.test_T<br>OBJECT ID PRIMARY KEY<br>/ <p>WORKAROUND:<br>None.<br><br>STATUS:</p>
Getting "ORA-01791: not a SELECTed expression" when selecting unified audit policies in tree mode (4376766)
ORA-01791 "Not a SELECTed expression" error when selecting unified audit polices in schema browser when in tree mode<br><br>Steps to reproduce the error: ... <ol><li>Connect to 19c or newer</li><li>Open Schema Browser and change to treeview mode</li><li>Expand Unified Audit Polices</li></ol>
NOT NULL constraints are not visible for object tables (4375908)
NOT NULL constraints excluded from object table scripts.<br>Steps to reproduce the issue:<br><br>Run the script below:<br>CREATE TYPE test_object_t AS OBJECT<br>(<br>id NUMBER,<br>hiredate DATE,<br>desc_t VARCHAR2 (255),<br>MEMBER FUNCTION f_test<br>RETURN VARCHAR2<br>) NOT FINAL<br>/<br><br>CREATE OR REPLACE TYPE BODY test_object_t<br>IS<br>MEMBER FUNCTION f_test<br>RETURN VARCHAR2<br>AS<br>BEGIN<br>RETURN 'V1.0.0';<br>END;<br>END;<br>/<br><br>CREATE TABLE test_objects OF test_object_t<br>NOT SUBSTITUTABLE AT ALL LEVELS<br>(<br>CONSTRAINT test_objects_pk PRIMARY KEY (id)<br>)<br>OBJECT ID PRIMARY KEY<br>/<br><br>ALTER TABLE test_objects<br>MODIFY (hiredate CONSTRAINT hiredate_nn NOT NULL)<br>/<br><br>ALTER TABLE test_objects<br>MODIFY (desc_t CONSTRAINT desc_nn NOT NULL)<br>/<br><br>If you run describe test_objects; you see<br><br>TABLE test_objects<br> Name Null? Type <br> ----------------------------------------- -------- ----------------------------<br> ID NOT NULL NUMBER <br> HIREDATE NOT NULL DATE <br> DESC_T NOT NULL VARCHAR2(255) <br><br>notice the not nulls created before with the alter statements for HIREDATE and DESC_T.<br><br>The not nulls can be seen in the constrains and column tabs in schema browser.<br>The problem is that Toad does not show this information(not null) in any script anywhere (f4 , schema browser, schema compare or extract dll.)<br> <p>This is a bug.</p>
Multiple user script missing synonyms (4375738)
When a script is created for a user creation from an existing database, when selecting a single user, the script contains the synonyms creation statements but if you select multiple users (with the same options), the script generated does not contain the synonyms creation part.<br><br>Steps to replicate:<br><br>1.
- c command line option does not work when “Allow multiple copies of Toad” unchecked (4376049)
Steps to reproduce the issue: ... Uncheck “Allow multiple copies of Toad” Close and Restart Toad ... Start a 2nd copy of Toad with a -c user/password@db to make a connection ... Bug: The 2nd copy of Toad does not start, which is expected, but it also does not tell the first copy to make the connection
Getting error "ORA-00900" when clicking SYSTEM Tablespace (4375831)
Steps to reproduce the issue: ... Open Schema Browser ... Go to Tablespaces ... STATUS ... Issue fixed in Toad for Oracle 2024 R2 - v24.2.275.4664 (Released on Nov 4th 2024). ... The latest version of Toad can be downloaded here:
신제품 조합