goldenhistory.txt

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

  .  Improved and optimized the SQLBuilder's primary key and index information query.

Version 5.5 Build 340 Production - October 27, 2000
  .  Improved the text explain plan output so that plans will no longer be truncated.
  .  Added an option called 'Use simple plan output' to show the 'old style' plan.  If
       you don't have a newer version of the plan_table, you'll have to use the simple
       plan.
  .  Added a new section to the help file that is all about the Explain Plan output!
       This section was graciously supplied by Keith Wood.
  .  Fixed a bug where changes to the page options on the print preview window
       would not be used for printing.
  .  Added an option called 'Remember SQLBuilder Open Status' to the SQLBuilder
       options.  Checking this will make the SQLBuilder open on startup if it was
       open when the program was last closed.
  .  Fixed a problem when 'explain plan' statements contained prompt variables.
  .  Removed 'prompt' times (waiting for user input) from the script and statement timings.

Version 5.5 Build 339 Production - October 16, 2000
  .  Fixed a printing problem where the footer text would be off the bottom of the
       page on some inkjet printers.
  .  Added an option to the Tabs & Windows option page to allow the tabs to be
       'stacked' (all the tabs appear on multiple rows instead of one scrolling
       row.)
  .  Changed the 'Columns' list of the SQLBuilder to a listview showing column
       index, name, datatype, primary key and index information.  Abbreviations
       are 'P' for Primary Key, 'U' for unique index and 'I' for nonunique index.
       There is a new setting on the SQLBuilder option page to specify what to show.
       You can click the column headers to sort (click the same one again to reverse
       sort.)
  .  Added an option to the SQLBuilder option page called 'Only paste when Ctrl
       is down'  If this is checked, you must hold the Ctrl key down when double-
       clicking a table, or single clicking a column to paste the text into the
       current SQL Tab.

Version 5.5 Build 337 Production - October 4, 2000
  .  Now by default Tabs will be created to the right of the currently selected
       tab.  This can be returned to the old setting (create new tabs at the end
       of the tab list) using the setting on the new Tabs and Windows option page.
  .  Added the ability to reorder and rename tabs.  Just right click in the tab
       and you will see a list of tabs that can be edited and ordered.  You can
       drag and drop in the list or select one and click the up/down or edit
       buttons.
  .  Modified the handling of pasted records into the spreadsheet in edit mode:
     . Fixed a very slow index column lookup query when starting edit mode.
     . Got rid of the 'You need to refresh the query to updated inserted records'
         restriction.  If you insert a row and see the message 'Could not get
         ROWID after insert' please let us know ([e-mail])
     . Fixed a problem with pasting in records to the insert line when the SQL
         includes the ROWID (complained about data not fitting the # of cols.)  
     . Removed the restriction on pasting in inserts that aren't complete records.
     . Allow you to paste inserts at any column position (used to force the first
         column to be selected.)
  .  Added a new option to the Editor options page.  The option 'Allow cursor
       past end of line' is checked by default.  If you uncheck it, cursor movement
       will be more like Microsoft's code editing products.
  .  Changed the 'Ignore Future Errors' checkbox on the error popup window to
       read 'Ignore errors (for this run)' to signify that it is a temporary setting
       that will reset at the next script run.  Use the 'Ignore Errors' menu item
       off the 'Script' menu to turn off error reporting for this tab (stays until you
       close the tab or turn the setting off.)  Also changed the display of the error 
       window so that it won't give the continue option if you are just running one 
       statement in a larger script.
  .  Explain plan improvements.
     . Added an option called 'Show Plan as Text' on the general options page. If
         this options is checked then the explain plan shows as plain text.  If not
         then the plan shows up in the spreadsheet.
     . Removed the restriction that the explain plan can only work on a script
         that has one statement (the plan will be for the statement at the current
         cursor position (similiar to 'Run single statement at cursor'.)
     . Updated the plan output using Oracle's example plan output script.
  .  Modified the color settings on a number of the windows to use the standard
       system wide WindowsText color for fonts (it was using black which caused
       obvious problems if you used a black window background setting.)
  .  Add Comment/Uncomment block command to the edit menu.  This will add or remove
       '--' style comments from each selected line.
         
Version 5.5 Build 330 Beta - August 28, 2000
  .  This beta release of Golden fixes a bug in build 329 that caused
       single statements to not run (unless they had a rem before them, doh!)
  .  Added a single statement script to our test script list to catch this in the
       future.

Version 5.5 Build 329 Beta - August 25, 2000
  .  This beta release of Golden is to fix an incompatibility
     with Computer Associate's Innoculate Antivirus software.
  .  Added a 'Use alternate query for user list' option to the
       SQLBuilder.  Checking this option will use a slower but
       more accurate query for the 'All Objects' user list.
  .  Fixed a parsing bug related to REM inside a statement.

Version 5.5 Build 326 Production - July 27, 2000
  .  Fixed a problem with the editor's right click menu.
  .  Improved the script parser's handling of comments.
  .  Added a way for companies to disable the password saving
       feature (send email for details.)

Version 5.5 Build 325 Production - July 18, 2000
  .  Allow users to change the Open and Save dialog boxes file filter
       settings (Open/Save File Filters page in the options.)
       page in the options.
  .  Decreased the amount of memory used by datasets a bit.
  .  Fixed several minor sql parsing bugs.
  .  Made the editors select colors match the current user's
       control panel color settings.
  .  Fixed a display problem when a single line in the editor was over
       about 5000 characters (shouldn't happen very often!)
  .  Fixed a problem with the favorites menu if the menu directory
       had spaces in it.
  .  Fixed a problem with filenames with multiple '.' characters.
  
Version 5.5 Build 324 Production - May 16, 2000
  .  Fixed a problem with the SQLBuilder where users with 'SELECT ANY
     TABLE' system privilege wouldn't see all the other object owners
     in the 'All Objects' pane.

Version 5.5 Build 323 Production - May 8, 2000
  .  Added the ability to limit the number of records returned from
       select statements.  The setting is on the General page of the
       Options window.  You can also set the value by clicking on the 
       middle 'status pane' that shows affected records.  The status
       pane message will be red and say something like 'Select stopped
       after xxx records' if the limit was reached.
  .  Improved Golden's READ ONLY mode.  Run Golden in Read Only mode by
       starting it with -ro as a commandline parameter.  There is also
       a registry key that you can set to force read only mode (email
       [e-mail] for details.)  Read only mode removes
       the data editing feature and stops any sql statement except select
       and exec.  Note that 'local' commands (like DESC) still run fine.
  .  The CONNECT command will now default to the current private or 
       public database (so you can leave off the @ part if you are already
       logged in.)  Fixed a case where CONNECT wouldn't run unless you were
       already logged in.

Version 5.5 Build 320 Production - May 1, 2000
  .  The undo/redo information was being cleared each time a script
       was run.  This has been fixed.

Version 5.5 Build 318 Production - April 27, 2000
  .  Fixed a display problem with the float datatype.
  .  DBMS_Output window is properly reset when you re-login.
  .  Added keyboard cell selection in the spreadsheet. (shift+arrows)
  .  Now whenever a script is parsed Golden will trim any whitespace
     characters from the end of all lines.  This should solve the
     'invalid character' error when statements have spaces and such
     after the ';' character.
  .  Fixed a problem where the footer text would be cut off on printouts
     to printers with wide non-printable margins.

Version 5.5 Build 316 Production - April 13, 2000
  .  Fixed not being able to update records (in edit mode) when field names
     were longer than 26 characters.
  .  Fixed an error message when setting the spreadsheet to transpose mode
     before running a query.
  .  Fixed a number of problems with the login window's quick list popup
     menu actions.
  .  Fixed the hotkey display on the popup menu for 'Close Tab'
  .  Fixed accessing the file menu from a running tab.

Version 5.5 Build 315 Production - April 6, 2000
  .  Fixed a problem where user would see a pl/sql error reported
     when running some types of queries (inline views.)
  .  Fixed printing problems if you made paper size changes right
     before printing.

Version 5.5 Build 314 Production - April 6, 2000
  .  Fixed a bug when compiling triggers.  Golden would try to bind
     the :new/:old words.
  .  Added Printer Settings button to the page settings window
     so that you can change the paper size and orientation.
  .  Fixed a bug when describing partitioned tables.

Version 5.5 Build 311 Production - April 3, 2000
  .  Mostly small bug fixes and changes from RC1.

Version 5.5 Build 310 Release Candidate 1 - March 27, 2000
  Lots of changes!
  
  Important notices:
  .  Note that your font settings for SQL text and spreadsheet text
     will return to defaults when using this version.  You will have
     to reset them in the options window.  True type fonts
     print best!
  .  We are now using a third party grid component instead of our
     homegrown one.  The new grid is very powerful and will give
     us the ability for new features down the road.  One big difference
     is that you must start with the mouse cursor at the left side of a
     cell in order to click and drag a multi-cell selection.  The cursor
     will change slightly to indicate that you are in multi-cell 
     selection mode.

  Printing:
  .  Hugely improved page setup window.
  .  Custom headers and footer on printouts.
  .  Much improved printing with previews of both SQL and spreadsheet. 
  .  Ability to print spreadsheet without going through the preview screen.
  .  Ability to print SQL with syntax highlighting or as plain text.
  
  Spreadsheet:
  . Selection changes:
    . You must click on the left part of a cell to start a multi-cell
      drag selection.
    . You may select multiple rows or columns.  Use Ctrl-Click to select
      discontinuous columns or rows.
  . Edit mode changes:
    . Paste multiple records when editing (both update and insert)
    . Delete multiple records when editing.
    . Full editing of CLOB and LONG values (used to have a problem once
      longs got too big.
  . Proportional scrollbars.
  . View text viewer by double-clicking a cell (changed from Ctrl-Click)
  . Right click column header to change alignment.
  . Right click top-left spreadsheet cell (on header line) to autosize 
    visible rows.  Shift-Right click it to autosize all rows.    
  
  SQL Editing:
  . SQL Error position now shown for Net8.0.x clients!
  . New bracket find and selection commands (Ctrl-B)
  . Search and replace enhancements.
  
  Interface:
  . Program Options menu item moved to Tools menu (like Microsoft's apps.)
  . Most recent files moves to bottom of file menu.
  . New print buttons on the toolbar.
  
  Connections:
  . Disconnect menu item (under login) to disconnect from all databases 
    (allows leaving Golden running while database is restarted.)
  . Better error handling when session is killed or disconnected.
      Autoreconnect will be attempted (you will be notified since data
      may have been rolled back.)
    
  General:
  . Slightly less memory intensive.
  . Removed 'Update only changed fields' setting.  It makes much more sense
    to only update changed fields (as all other tools do.)
  . Ignore Net8 option removed (not needed anymore!)

Version 5.5 Build 302 BETA - January 6, 2000
  Fixed a bug where Golden would incorrectly detect bind variables inside
  string literals. 
  
Version 5.5 Build 301 BETA - January 4, 2000