Oracle SQL Developer v 1.1 Evaluation Release 3 - Known Issues

Posted by Anantha Narayanan on Thursday, July 5, 2007 / Labels:
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.