Oracle SQL Developer v 1.1 Evaluation Release 3 - Known Issues

Contents

1. General
2. Connections
3. Creating and Modifying Objects
4. PL/SQL
5. Preferences
6. Reports
7. Schema Diff
8. Linux Only Issues
9. Oracle 8.1.7 (Not Certified)

1. General

• Settings from previous release not migrated
• Extensions for SQL Developer 1.0 no longer work 1.1.
• You can't invoke SQL*Plus for users with TNSNAMES Connections.
• Query Builder
  • Where Clause for a self referencing table is incorrect.
  • Tables are not listed alphabetically.
  • You can't always drag a table onto the white space. Workaround: Close and reopen the Query Builder.
  • Two consecutive queries give an Ora error. Workaround: Add ';' to the first, before adding second query.
• Icons to be updated for production release.
  • PL/SQL icons require more definition
• There is an error when you add External Tools. This is not causing any SQL Developer errors. You can ignore it.

2. Connections

• Cannot connect to remote database as OPS$ account.
• Import Connection: Does not permit replacing existing connections.

3. Creating and Modifying Objects

• For Functions, Packages & Procedures: Invalid icons not always shown for invalid objects.
• Create new Database Link. Failure occurs if you drop and try to recreate a database link with the same name.
• It is not possible to create a second index for a materialized view.
• Importing Data into Table using Excel spreadsheet has some issues.

4. PL/SQL

• Can't save spec and body in same file.
• Remote debugging works only with IP, not with hostname.
• In some instances compiling PL/SQL results in a 'token' error.

5. Preferences

• File Types: Associate File Extension With SQL Developer, Preference is not saved.(Windows only)
• Database - > Worksheet parameters Unable to run using @ or Start when you set the working directory. Workaround: Use the full path.

6. Reports

• SQL Developer hangs or throws an exception when you rerun the Sessions report.

7. Schema Diff

• The Tools menu now shows an item "Schema Diff". This is not functional yet.

8. Linux Only Issues

• Browsing
  • Views > Data Tab - Actions not working.
• Connections
  • Core dump while expanding a connection created using connection identifier.
  • New connection using connect identifier gives ocijdbc10 error.
• SQL Worksheet
  • Describe - F4 key does not work correctly.

9. Oracle 8.17 (NOTE: SQL Developer is only certified for database 9.2.0.1 and above)

• There are general issues with browsing 8.1.7 objects.

Courtesy: http://www.oracle.com/technology/products/database/sql_developer/files/knownIssues_v1_1.html

Download Oracle Sql Developer here