Chat now with support
Chat with Support

Space Manager with LiveReorg 9.2 - Release Notes

New Features

New Features and Enhancements

Space Manager 9.2

Space Manager 9.2 includes the following new operating systems and enhancements:

Operating systems support:

  • Windows 11

  • Windows Server 2022

Enhancements:

  • Space Manager now supports the Identity Column feature on Oracle 19c for Live Reorganizations.

  • Space Manager now displays sub-partition templates in the DBA_SUBPARTITION_TEMPLATES view, even after performing Live Reorganizations.

  • Space Manager now supports the Index with Compress Advanced High option.

  • Space Manager now supports the READ_ONLY property option for partitioned tables.

  • Space Manager now supports the sub-partition count columns.

Space Manager 9.1

Space Manager 9.1 includes the following new features and enhancements. This release of Space Manager is upgraded to install server agent on Windows 64 bit platform.

Supported Platform versions as below:

Database Server Operating System

Windows

Red Hat® Enterprise Linux 8.4 and 8.6 (64 bit)

IBM® AIX 7.1 ,7.2 and 7.3

Oracle Database 12c R2 and 19c
Operating System

Windows Server 2016 Datacenter

Space Manager 9.0

Space Manager 9.0 includes the following new features and enhancements.

This release of Space Manager is upgraded to support Oracle Database 19c.

Supported Platform versions as below:

 

Database Server Operating System

Oracle Solaris 11 and 11.1

IBM® AIX 7.1 and 7.2

Red Hat® Linux Advanced Server 7.4

Oracle Database

12c R2

19c

Operating System Windows 10

Note: License validation will happen in Space Manager, QSA independently will not authorize the license key.


Deprecated Platforms

The following platform is deprecated in the current version.

IBM AIX 7.1


Resolved Issues

The following is a list of issues addressed and enhancements implemented in this release of Space Manager.

Space Manager 9.2

Feature Enhancement / Resolved Issue Defect ID
Check constraints After performing a reorg, if a table has any check constraints, the Check Constraint option is automatically disabled. SPC-1084

Space Manager 9.1

Feature Enhancement / Resolved Issue Defect ID
Double Database Instance Issue An issue with double database entry appearing at the left side of the Windows Explorer has been resolved. SPC-1022

Space Manager 9.0

Feature Enhancement / Resolved Issue Defect ID
Renci Upgrade The Renci SSH.NET library is upgraded from version 2012.3.9 to 2020.0.1 in Space Manager to help resolve connectivity issues with the oracle servers running on the latest AIX operating systems. SPC-906
Partitioning Wizard An issue with the "Move to Tablespace" functionality in Space Manager is resolved. SPC-908

Known Issues

The following is a list of issues known to exist at the time of this release.

Feature Known Issue and Workaround (if applicable) Defect ID
General When running the Space Manager client (64-bit) in a 64-bit environment, some users might encounter the following error when attempting to submit a standard or live reorg script: “Error creating script group: Could not load file or assembly ManagedQP5.dll or one of its dependencies. is not a valid Win32 application.” SPC-409
Domain Indexes

Reorganizing tables with Domain indexes. Space Manager provides limited support for Domain indexes when performing reorganizations and warns that you might encounter a problem because of the Domain index. Space Manager scripts the reorganization of the domain index correctly. However, the underlying implementation of the index type may be very complex, and some unforeseen dependencies may cause runtime errors.

Important: It is recommended that you test the reorganization of a table with a Domain index on a non-production version of the table to make sure Space Manager reorganizes both the table and index correctly before you reorganize your production table. 

N/A

Installation

Error when installing QSA on Windows for Oracle Database 12cR2. Some users might encounter an "Error running setup" error after attempting to install the QSA Server Agent on Windows for Oracle Database 12c R2. Workaround: If you encounter this issue, contact Quest Support for assistance.

SPC-491
Live Reorg

Error when running Live Reorg on Oracle Database 12cR2 in Windows. Some users might encounter the following error when attempting to run a Live Reorg script on Oracle 12c R2 in a Windows environment: "350: Aborted QSA - 20391 ORA - 01403 during internal SQL." Workaround: If you encounter this issue, contact Quest Support for assistance.

SPC-493
Object Properties Attempting to open the Object Properties dialog for a recently-created partitioned table using a Direct connection type resulted in an error.

SPC-482

Partitioning Wizard After creating a table partitioned by range with a global index, using the Partitioning Wizard to change the partitioning method from range to hash unexpectedly changed to the index's locality to local.

SPC-483


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating