goldenhistory.txt

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

Golden32 History:

Version 5.7 Build 429 - May 26, 2004
  .  Fixed:  Synonyms with DBLinks that point to public synonyms now show detail information in
               the SQLBuilder.

Version 5.7 Build 428 - May 21, 2004
  .  Added:  Readonly mode can now be forced by having a file called "readonly.lic" in the same
               directory as the Golden32.exe application.  This probably only makes sense in situations
               where the user can't delete this file (i.e. running from a readonly network directory.)
               Note that this is just one of the ways to force Golden into read only mode (please let
               us know if you would like the documentation for the various readonly mechanisms.)
               As always the best way to enforce rights is using Oracle's own grant/privilege system.
  .  Added:  You can now ignore errors in statements using:
                 set errors off
                   or
                 whenever sqlerror continue
               you can turn errors back on using
                 set errors on
                   or
                 whenever sqlerror exit
                   (note that exit was used for SQLPlus compatibility and Golden won't exit if it
                   encounters an error, it will just show the error as usual.)
  .  Added:  Ctrl-Clicking items in the SQLBuilder will now always perform a paste.
  .  Fixed:  Synonyms that point to DBLinks now show detail information in the SQLBuilder.  Note
               that synonyms that have DBLinks that are private to another schema will not show
               detail information.
  .  Fixed:  SQLBuilder option "Add table name to column on paste" is now working.

Version 5.7 Build 427 - April 14, 2004
  .  Fixed:  Queries with VArray columns would fail with a typecast error.

Version 5.7 Build 426 - April 9, 2004
  .  Fixed:  Power Users (users with 'Select any table') wouldn't see all of the available
               schemas in the SQLBuilder's 'All objects' tab.  This now defaults to show all
               schemas with accessible objects.  If this is slow then you may want to set the
               'Userlist Performance' option to 'All Users Fast Query'.

Version 5.7 Build 425 - April 8, 2004
  .  Fixed:  Double-click word selection wasn't honoring word delimiters.

Version 5.7 Build 424 - April 5, 2004
  .  Improved:  Changes to keep from picking up 'stray' tnsnames.ora files.
  .  Fixed:  Selecting range of cells in the spreadsheet using the Shift-Arrow keys now
               keeps the current cell in view.

Version 5.7 Build 423 - March 29, 2004
  .  Fixed:  Some operations (i.e. Replace and Paste) weren't scrolling the caret into view.

Version 5.7 Build 422 - March 26, 2004
  .  Improved:  Added more statement descriptions to statusbar and log (i.e. "Commit succeeded")
  .  Improved:  Changed the text and added a lookup button for OCI DLL on the Login Options window.
  .  Improved:  Changed the error message on explain plan failure to include the Oracle error
                  message and to include a note about putting the cursor inside the statement
                  to be explained.
  .  Fixed:  A problem with canceling queries not showing the partial results.
  .  Fixed:  A problem with canceling statements that could cause an "Access violation" message.
  .  Fixed:  A problem with REFCURSORS that could show an "Invalid argument" error message.
  .  Fixed:  Choosing some of the right-click menu paste options of the SQLBuilder wouldn't
               set the focus at the end of the text when 'move focus on paste' option was checked.
  .  Fixed:  REM was being syntax highlighted even if it wasn't the first word in a line.

Version 5.7 Build 421 - March 11, 2004
  .  Added:  New SET option called RECORDLIMIT.  This is a 'script' way to set the number
               of records that will be returned at maximum for the current tab.  A value 
               of -1 means unlimited.
                 i.e. SET RECORDLIMIT 2000 or SET RECORDLIMIT -1
  .  Fixed:  Fixed a parsing issue with 'local' statements followed by line comments.
               i.e.: set echo on -- setting echo on!
  .  Fixed:  Fixed a problem with Explain Plan if server was version 9 and client was pre-9.

Version 5.7 Build 420 - March 8, 2004
  .  Added:  New option "Don't backup workspaces" to stop Golden from keeping the three
               historical workspace backups *.bk1-*.bk3.
  .  Fixed:  In transposed mode it was possible for columns to be wider than the entire grid
               and therefore impossible to resize.

Version 5.7 Build 419 - March 2, 2004
  .  Added:  The ability to ignore columns in the source file when importing data using
               ImpExp (Golden's import/export tool.)  Here are the instructions:
              This version adds a button with an 'X' on it that adds '-- IGNORE --' to 
              the column list. You have to click the add button and then drag the IGNORE
              item to the correct position in the columns. The column list on the left side 
              must have the same number of items as columns in the source file so you need 
              IGNORE items for each column that you want to skip in the source file.
  .  Improved:  The keyword list has been improved with many more keywords.  The keyword
                  list in the options now only holds added keywords.  You can also remove
                  keywords by prefixing them with "-" (i.e. -SELECT)
  .  Improved:  The SQLBuilder now shows package/type methods as well as arguments.
  .  Fixed:  Describing packages with overloaded functions and procedures of the same
               name would cause an error message.
  .  Fixed:  Copying a row from the grid while in edit mode would include the ROWID.

Version 5.7 Build 418 - November 17, 2003
  .  Improved:  Improved the explain plan output and error reporting.
            Note that if you have 'Show explain plan as text' checked and use Oracle 9.2
            it will show the output using the new dbms_xplan package.
  .  Added: Added a new option called 'Show alternate unsaved indicator'.  Checking this
            option causes the unsaved tabs to show a small circle on the lower right side
            instead of just turning the caption red (which was a problem for colorblind
            users.)  This options is on the 'Tabs and Windows' page.
  .  Fixed:  Couldn't change the alignment of the last column in the spreadsheet.

Version 5.7 Build 417 - October 3, 2003
  .  Improved:  Improved object detail performance in the SQLBuilder when objects have a
            lot of constraints and indexes.
  .  Improved:  More detailed performance information in the connection diagnostics window.
  .  Added: 'Copy Results' options now include 'Copy Titles Only (tab delimited)' and 
            'Copy Titles Only (comma delimited.)
  .  Added: New right click menu when right clicking spreadsheet header columns.  Now there
            are 'Align Left', 'Align Center' and 'Align Right' options.  This cleans up the
            old toggle feature and allows us to add new 'column' level features in the
            future.
  .  Added: New right click menu for the upper left spreadsheet cell with Autosize options
           (also on the standard spreadsheet right click menu and 'Results' menus.)  New
           Autosize options for 'data and titles', 'data only' and 'titles only' without
           having to go to the options window.
  
Version 5.7 Build 415 - September 23, 2003
  .  Improved:  More performance information in the connection diagnostics.
  .  Improved:  Now using USER_CONSTRAINTS lookup when possible to help with performance
            problems in the ALL_CONSTRAINTS system view.  If table object detail 
            performance is slow and the cause is the constraint lookup contact us for
            a fix involving adding a new system data dictionary view.  Connection
            diagnostics now gives a breakdown of the performance for object details.
  .  Improved:  SQLBuilder object list performance for large schemas. (i.e. pulling
            in 10,000 tables is now 2-3 times quicker in most cases.)
  .  Improved:  Improved object detail performance if setting "Column Information"
            is set to "Columns Only"
  .  Improved:  Window for prompt and pause messages now remembers its position.
  .  Improved:  Now doing a spreadsheet column autosize before showing the pause or prompt
            windows.
  .  Fixed: NUMBER datatypes with no precision and 0 scale are now correctly shown as
            NUMBER(38) instead of just NUMBER in DESC and the SQLBuilder.
  .  Fixed: NCHAR and NVARCHAR2 types will now show their correct length in DESC and in the
            SQLBuilder.
  .  Fixed: Right clicking pk, fk, and index column headers in the object detail sqlbuilder
            window wasn't working if the window was horizontally scrolled.
  .  Fixed: Error if SQLBuilder keyword list was empty.

Version 5.7 Build 412 - August 15, 2003
  .  Added: The column detail list of the SQLBuilder will now show foreign key constraints.
  .  Added: Right clicking a Primary Key, Foreign Key or Index column header in the object 
            detail list of the SQLBuilder will show the DDL statement for that constraint 
            or index.  (i.e. right click the 'PK', 'FK', 'UX' or 'IX' header text.)
  .  Added: You can now assign bind variable to prompt variables.
              REM Here's a cool example!
              REM Declare a bind variable.
              var BindSpoolFilename string;
              REM Run a pl/sql block that fills the bind variable with a filename including
              REM   the current date.
              begin
                select 'c:\spoolfile'||to_char(sysdate,'yyyymmdd')||'.log'
                into :BindSpoolFilename
                from dual;
              end;
              /
              REM Define a prompt variable and set it to the value of the bind variable.
              define SpoolFilename = :BindSpoolFilename;
              REM Create a spool file with the computed name.
              spool &SpoolFilename;
              select * from tabs;
              spool off;
  .  Improved:  Showing column details (after clicking a table, view or synonym)
            in the SQLBuilder was not being run in a background thread.  This has
            been fixed and should also be faster than earlier versions.
  .  Improved:  Optimized data dictionary queries used by the SQLBuilder.
  .  Fixed: Headers and footers now work for printing SQL.
  .  Fixed: Doing a find & replace of "\n" with "\r\n" (replacing a linefeed with a
              linefeed/carriage return pair) would cause a null character to get inserted
              in some cases.
  .  Fixed: Error if var statement was used to redefine a cursor that was currently
            displayed in the spreadsheet.

Version 5.7 Build 410 - July 17, 2003
  .  Fixed: Problems with printing transposed results.
  .  Fixed: Problem with exporting large result sets to Excel if the user
       switched to Excel before the export was complete and changed active
       worksheets.

Version 5.7 Build 409 - July 2, 2003
  .  Added: Cell detail window popup from the scratch results window.
  .  Fixed: The scratch results window now shows moved columns correctly.
  .  Fixed: The header font of the scratch window wasn't being set properly.
  .  Fixed: popup menu on the scratch results window.
  .  Fixed: Autorun from the favorites menu failures causing tab to lock.

Version 5.7 Build 408 - June 26, 2003
  .  Fixed a problem with copying data out of the spreadsheet if columns had been moved.
  .  Now transposed data can be exported to excel and csv files.

Version 5.7 Build 407 - June 17, 2003
  .  Fixed a problem with the text viewer where it wasn't displaying various line break characters
       properly in the Text mode.  

Version 5.7 Build 406 - June 16, 2003
  .  Fixed a problem with handling different character sets in the editor and spreadsheet
       font settings.

Version 5.7 Build 405 - June 12, 2003
  .  Spreadsheet Columns can now be re-ordered by selecting them and then dragging
       them to the new position.
  .  SQLBuilder Changes:
       Added option called 'Single click keywords and columns' which is on by
         default.  Turning this off makes it so that you must double-click 
         keywords and columns in the SQLBuilder to paste them.  This is better
         for people who use the keyboard instead of the mouse for the SQLBuilder
         and also cuts down on accidental pastes while just trying to scroll the 
         various lists.  This may become the default (double-click to paste) in
         the next version.  Please let us know if you have strong opinions on this!
       Added option called 'Move focus to editor after paste'.  This option is off
         by default.
       Improved keyboard handling for all SQLBuilder controls.
  .  Added Shift-Arrow selection handling to the scratch window.
  .  Improved Connection Diagnostics information.
  .  Fixed situations where popup windows would display off the screen.
  .  Fixed a problem where the SQLBuilder wouldn't work with default logins.
  .  Fixed a problem with the spreadsheet scrollbar if 'clear on script run' was on.
  .  Fixed a parsing bug with queries in edit mode containing ''.
  .  Fixed a DESC[ribe] bug with spaces before the statement terminator.

Version 5.7 Build 402 - May 7, 2003
  .  Fixed a problem where changing the font options wouldn't save as defaults.

Version 5.7 Build 401 - May 6, 2003
  .  Fixed a problem where a parsing error could make a tab stop responding.
  .  Fixed the SQLBuilder's search function so that searching will 'wrap' when it reaches
       the top or bottom.
  .  Enabled incremental searching on the SQLBuilder trees.

Version 5.7 Build 400 - May 5, 2003
  .  Added a 'Change Password...' item under the File menu.
  .  Added support for TIMESTAMP, TIMESTAMP WITH TIMEZONE, INTERVAL YEAR TO MONTH,
       and INTERVAL DAY TO SECOND datatypes.
  .  Greatly improved Golden's ability to run multiple long scripts without 
       affecting each other.
  .  Added Enter and Shift-Enter to the SQLBuilder searching keys (along with the 
       up/down keys and buttons.)
  .  Reduced the memory used by the option objects.
  .  Reduced the memory used by datasets (and improved speed)
  .  Vastly improved SQLBuilder with unlimited objects and much faster handling.
  .  Changed keyboard control of SQLBuilder slightly.  Use shift-arrows to move through