goldenhistory.txt

oracle数据库备份与恢复的详细资料集合

       object list without refreshing the column information when desired.      
  .  Fixed a problem where functions outside of packages would be DESCribed as procedures.
  .  Fixed a problem when copying spreadsheet results when in transpose mode.
  .  Fixed the problem where second instance would start when loading .sql file from
       Windows Explorer.

Version 5.6 Build 387 - October 2, 2002
  .  Added the script statement "EXPORT EXCEL" which will export the current spreadsheet
       results to Excel.
  .  Fixed a slow logon problem for databases with a large number of users.

Version 5.6 Build 386 - September 18, 2002
  .  Fixed a problem where Golden wouldn't use the dba_ views for lookups.
  .  Fixed a bug related to importing data containing multiple field qualifiers in a row.

Version 5.6 Build 385 - September 10, 2002
  .  Fixed a parsing bug related to trailing '--' type comments on the delimiter line.
  .  Fixed a problem with statements containing multiple single '&' prompt variables
       after a '&&' define of the same variables.
       (i.e.:  select '&&fish', '&fish', '&fish' from dual;)

Version 5.6 Build 385 - September 10, 2002
  .  Fixed a parsing bug related to trailing '--' type comments on the delimiter line.
  .  Fixed a problem with statements containing multiple single '&' prompt variables
       after a '&&' define of the same variables.
       (i.e.:  select '&&fish', '&fish', '&fish' from dual;)

Version 5.6 Build 383 - July 23, 2002
  .  Added handling for changing your password if it has expired (Oracle 8+ feature.)
  .  ImpExp will not allow importing if the DBA has set the users mode to READONLY.

Version 5.6 Build 382 - July 2, 2002
  .  Added a 'Read Only' checkbox to the login window.  Sessions marked read only
       can only run select and exec statements.  Note that it is also possible for a
       dba or system administrator to force all users or specific users to read only
       mode.  Please let us know if you would like this information.  As always, the
       best way to enforce user rights is with Oracle's own grant/rights system.
  .  Added a new 'Find in results' option to the Results menu.  Note that currently the search
       goes left to right and top to bottom.  More options to come!
  .  Added support for the commands:
         SET FEEDBACK ON/OFF  -- Turns off feedback in spool files
         SET HEADING ON/OFF   -- Turns off column heading info in spool files.
       This is useful if you want to make a spool file of dynamically generated SQL statements.
       Here is an example:
         REM Script to create analyze table statements
         set feedback off
         set heading off
         spool c:\spool.txt;
         select 'analyze table ' || table_name || ' estimate statistics;' from tabs;
         spool off;
         REM And then execute the spool file using:
         REM @c:\spool.txt;
  .  Fixed a problem opening files on machines with the Netware client installed.
  .  Fixed a problem where select statements that started with an open parenthesis
       wouldn't parse correctly.
  .  Fixed a problem where 'Find again' was disabled.
  .  Fixed a problem where an open workspace would be mistakenly marked as modified.
  .  Fixed a problem where it was possible to move 'pane splitters' so that they couldn't
       be moved again.

Version 5.6 Build 375 - March 18, 2002
  .  Fixed a bug related to running statements that didn't return any records after
       setting the spreadsheet to transposed mode.
  .  Added shift-keyboard selection handling back to the spreadsheet (accidently removed
       in an earlier update.)  Now Shift-PageUp/PageDown/Home/End should work correctly.
  .  Changed pasting into the spreadsheet during edit mode.  When pasting into a single record
       the focused cell will not change.  Whe pasting into multiple records the current cell
       will move to last record pasted but stay at the current column position.
       
Version 5.6 Build 374 - February 20, 2002
  .  Fixed a very minor parsing bug.

Version 5.6 Build 373 - February 14, 2002
  .  Changed the parsing so that it now allows white space or '--' style comments
       after the ';' at the end of an SQL statement (on the same line.)
  .  Put back the hotkey options for Golden, PLEdit and Goldview on the Tools menu.

Version 5.6 Build 372 - February 13, 2002
  .  Fixed a parsing problem with build 370 related to whitespace at the end of a script.
  .  Fixed a problem where build 370 wouldn't allow edit mode on a synonym.

Version 5.6 Build 370 - February 11, 2002
  .  New menu system and toolbars.  Favorites menu will now scroll if it doesn't fit onscreen
       even for Windows 95.
  .  Improved the DESC[ribe] command to include describing packages.
  .  You can now edit queries containing more than one table.  Note that you can only
       edit the columns from the first table in the FROM list.  If the query results contain
       more than one column with the same name as a column in the edit table that the first 
       one in the list will be used for that column.
       (Alternate wording:  Be aware that if the results contain multiple columns with the
        same name that are in the edit table's column list then the first one in the result
        set will be used to edit that column in the edit table.)
        Columns that can't be edited are shown in red text.  The edit table is now shown on
        the edit spreadsheet's toolbar.
  .  Added 'Export to CSV' and 'Export to XML' to the Results menu.
  .  Added the ability to login as SYSDBA or SYSOPER.  To do it just add ' AS SYSDBA' or 
       ' AS SYSOPER' to your login name.  The Conn[ect] command also supports this.
  .  Removed the 'Character Set' setting from the options.  You can now set
     the character set of the editor and spreadsheet using the font 'script'
     settings on the font selection window.
  .  Added the option 'Ignore this error for rest of script' to the error window.
  .  Greatly improved the script parsing speed (noticeable on scripts > 5000 statements.
  .  Added a 'Rename Tab' command to the popup tab menu.
  .  Fixed a problem where user would be prompted to save workspace even if it didn't 
       need saving (under certain conditions.)
  .  Fixed problem with describing objects with dblinks containing '.'.
  .  Fixed a problem with Tabs as Spaces and block indent.
  .  Fixed a problem with clipboard operations on the find/replace windows.
  .  Fixed a problem where spool to file data wasn't aligned properly.
  .  Fixed a problem where you couldn't use the Page Setup window to change the spreadsheet
       print title unless you were viewing the print preview.

Version 5.5 Build 363 Production - August 15, 2001
  .  Changed the Workspace saving so that it will create and maintain three historical
       backups of the workspace file (named workspace.ext.bk#)  Added a verify after write
       feature as well as a few other sanity checks.  This is due to a user report of data
       loss in a workspace file.  No bug has been found with the saving code but perhaps these
       changes will shed some light on the subject (it will help if a network glitch or 
       something causes a workspace file loss.) If anyone has had problems with their 
       workspace files please contact us at [e-mail]!
  .  Fixed a problem where the auto-reconnect feature wouldn't preserve the date format.
  
Version 5.5 Build 362 Production - July 18, 2001
  .  Fixed a problem when pasting data into the insert row after already typing in some
       data on the row.
  .  Fixed some problems with the export to Excel feature:
     .  Text fields are now formatted as 'Text' in Excel instead of 'General' which would
          convert text that looks like a number (i.e. '0000' to 0)
     . Fields with data over about 800 characters would cause Excel to crash.  Fixed by
          moving data containing large strings cell by cell which takes longer.

Version 5.5 Build 361 Production - July 3, 2001
  .  Fixed the popup menu for the dictionary object tree on the SQLBuilder.

Version 5.5 Build 360 Production - June 27, 2001
  .  Fixed a bug when using the SQLBuilder set for lowercase tablenames.

Version 5.5 Build 359 Production - June 25, 2001
  .  Fixed some problems with editing tables with non-standard table/field names.
  .  Fixed some problems with ImpExp related to tables with non-standard table/field names.
  .  Added some new choices to the SQLBuilder right click menus.
  .  Golden can now export data directly to Excel!  Just use the 'Export current spreadsheet
       contents' menu item off the 'Results' menu.
  .  Fixed a problem with the caret position when scrolling in certain conditions.
  .  Fixed a problem where having a single or double quote in a comment might be flagged
       as an unterminated string.

Version 5.5 Build 356 Production - April 26, 2001
  .  Now Golden will try to select a word at the current error position (if you have an
       error in your SQL statement.)
  .  Added support for SPOOL and SET ECHO ON/OFF SQLPlus commands.
      SPOOL FILENAME
          Will copy results and timings to a text file.  If the filename contains
          spaces enclose it with double quotes (i.e. SPOOL "C:\MY FILES\MY SPOOLFILE.TXT"
      SPOOL OFF
          Turns off spooling and closes the spool file.
      SET ECHO ON/OFF
          If ECHO is on then commands are placed in the spool file before the results.
  .  Removed script error reporting for unsupported SQLPlus commands that can safely be
          ignored (i.e. BREAK.)  Note that warnings for these commands will appear in the log.
  .  Fixed a bug where the 'Use favorites directory as default directory' option wasn't working.
  .  Fixed some parsing bugs with the '@' and 'START' commands.  Note that you have
       to surround filenames with spaces with double quotes. 
       i.e. @"C:\BENTHIC SOFTWARE\FISH.SQL" PARAM1 PARAM2
  .  Allow partial paths in @ or START commands
       i.e. @"SQL\FISH.SQL" PARAM1 PARAM2
       will use current directory or favorites directory as root depending upon what setting
       you have for 'Use favorites directory as default directory'  Note that current directory
       changes every time you load or save a file.

Version 5.5 Build 352 Production - March 6, 2001
  .  Fixed a bug where only the last page of a print job would print if you choose to print
       a range of pages.

Version 5.5 Build 351 Production - March 1, 2001
  .  Fixed a problem where running an explain plan would cause an error on the next script run.
  .  Changed the SQLBuilder so that it can't interfere with queries running in public tabs (and
       vice versa.)
  .  Fixed the table column lookup in the SQLBuilder to include the RULE hint.

Version 5.5 Build 350 Production - February 20, 2001
  .  Fixed a problem where default column values wouldn't be used for inserts
       in editing mode.
  .  Added 'read after insert/update' to editing mode so that you can instantly
       see what the record looks like after it gets posted to the database 
       (it may have been affected by default values or triggers.) Please let us
        know if you find any problems with it! -- [e-mail]
  .  Greatly improved the ability of Golden to cancel running queries!
  .  Added the ability to handle multiple REFCURSOR bind variables in a statement.
       Note that the refcursor displayed by default is the first one in the statement.
  .  Added a menu called 'Results' which lets you clear the spreadsheet and to 
       choose any REFCURSOR bind variable to view in the spreadsheet.  Note that you
       can use the 'Show last query results' menu item to go back to the last query 
       results after viewing a cursor.
  .  Added a menu item called 'Connection Diagnostics' to show some information about
       the Oracle client and database.

Version 5.5 Build 347 Production - January 24, 2001
  .  Fixed a bug in Build 346 which removed support for the commands SET ROLE, 
       SET TRANSACTION, SET CONSTRAINT(S)
  .  Got rid of the screen flash when creating and switching tabs.

Version 5.5 Build 346 Production - January 18, 2001
  New Features:
  .  Golden will now allow you to edit multi-byte character set databases (like UTF-8.)
  .  Completely rewritten printing system.
      . Improved print preview to include headers/footers for text and spreadsheet.
      . Added new 'Print line number' option for SQL printing.
      . Allow printing of page ranges and selected code.
  .  Cleaned up the DBMS_Output window and added an 'Enabled' switch.  Removed the 'Reset'
        button (just click 'Enabled' twice.)
  .  This version adds support for the following SQLPlus commands (with some caveats):
       ACCEPT:  Currently ignores the 'format' clause and 'datatype' clause.
       DISCONNECT:  This will return an error if the tab is public.
       PAUSE:  Note that this command could put up a dialog box from a tab that
           you are not currently viewing.
       PROMPT:  Note that this command could put up a dialog box from a tab that
           you are not currently viewing.
       SET SCAN OFF/ON:  Turns off/on scanning for prompt variables '&, &&'  Full
           support but this command is list as obsolete in the latest version of
           SQLPlus.  Replaced by SET DEFINE ON/OFF
       SET DEFINE OFF/ON:  Same as SET SCAN
  .  Golden will now handle abbreviated commands for all SQLPlus commands.
  .  New option to set file extension used for workspace files (on the 'File filters and
       extensions' page.)  Now all file extensions used by Golden can be customized!
  .  Can now set the file extensions of files that will appear in the Favorites Menu.
  .  The favorites menu can include directory shortcuts, so you can put a shortcut
       to another directory (say, on the network) in your favorites 'tree' and the files
       in the directory that the shortcut points to will be included on your favorites.
  Fixes:
  .  Fixed a problem with SQLBuilder's primary key display.
  .  Lots of improvements to the way workspaces are handled.
  .  Fixed a problem where choosing to replace the current sql when using the SQLBuilder
       would remove the undo information from the editor.
  
Version 5.5 Build 342 Production - November 15, 2000
  .  Added an option to limit the size of BLOB (and LONG RAW) data (default is to not 
       retrieve any BLOB data.
  .  Added the ability for ImpExp to handle BLOB (and LONG RAW) data (data is converted
       to HEX strings.)
  .  Fixed a rare problem with number() datatypes giving a 'data was truncated' error.
  .  Fixed a problem updating rows that contained full precision number values in edit mode.