Category
Product Version
Topic
Subtopic
Document for manual clean up on temporary objects created in the process of live-reorg (4345094)
When a Reorg is canceled or fails during the switch step, the cleanup utility will ask to perform a manual cleanup before clearing the failed Reorg from the job list. ... Connect with SPACE MANAGER USER while dropping the quest temporary tables.
How to Auto Approve All Scripts (4352733)
When generating a reorg script in Space Manager the Switch option defaults to 'Upon User Approval'. ... It is possible to select the Switch option. ... This changes the behaviour of a Live Reorg when the tables are ready to be switched.
Access Violation during Simulation of Reorg (4352759)
Whilst generating a reorg script a simulation is run to check space and other possible issues. ... Given this scenario the simulation aborts and reports an Access Violation. ... This can be caused by a missing QSA parameter.
Unable to find the QSA manual installation download for Linux 2.6 (4351767)
The SupportLink site does not seem to offer a manual installation download for Red Hat Enterprise Linux AS release 4 (Linux 2.6). ... There have been no changes required to QSA for this platform since version 2.1 of the O/S, therefore the Linux 2.1 QSA installer is applicable to Linux 2.6.
How to run the package quest_spc_find_long for all tables in a tablespace. (4351696)
The package quest_spc_find_long will calculate the size of longs held in a table and allow Space Manager to choose the optimal reorg method for the table. ... The following code will run quest_spc_find_long for all tables in a tablespace...
Error during snapshot job: "ORA-00600: internal error code, arguments:[kksumc-xpin-required]" (4292271)
When Capacity Manager runs the scheduled snapshot job on the monitoring database it produces an ORA-0600 error. ... The job doesn't complete successfully ... This is due to an Oracle bug which is fixed in a later patch of Oracle.
Received error: QSA-20391 ORA-01631:max # extents () (4325910)
QSA-20391 ORA-01631:max # extents () From the script log, there is no additional information on which specific table had reached the max number of extents. ... 1. The tablespace used for QSA installation has reached the max extent limit set to it.
Actual used information is different between Oracle data dictionary and Quest Repository (4258382)
Users select copy the objects statistics from Oracle Data Dictionary into Space manager Repository, and see the mismatch information field on Actual used when he/she select look up object statistics in Oracle Data dictionary and look up the object statistics in Quest Repository.
Missing information on Index management statistics Report (4227411)
Missing information on Index management statistics Report even analyze was done daily. ... User can capture the statistics into space manager repository by following:
An entry for a repository has been found in Quest tables located on database <alias> But no (4313391)
An entry for a repository has been found in Quest tables located on database <alias> But, no repository was found. ... The application cannot connect to <alias> ... The database once had a repository installed (under a separate username than other quest products) and the repository objects have since been dropped.
How to download Space Manager with LiveReorg 6.x from Supportlink? (4266039)
In order to obtain a copy of the installation file contact Support team using below link by submitting a Service Request:
Error: "QSA-20311 Table conflict with script already executing;" (4326619)
Error when starting a job on the QSA, after a previous script execution: ... For example, a reorg job runs successful once, but then when rerunning the job, this error occurs. ... The QSA (qexecd) is waiting on a PID.
Error when installing Quest Server Agent (QSA): "QSA-20373: Required Quest Script not found"</ (4260254)
The Quest script package is not installed on the database server or incompatible version was installed. ... Install or upgrade Space Manager database object prior to installing or upgrading QSA. ... To install or upgrade database object:
What are the privileges to install and run space manager client? (4259712)
What are the privileges to install and run space manager client? ... To install Space manager client: You need to login as administrator (a member of the Local Admin Group) or Standard Windows user (member of Local Power Users Group).
Aborted ORA-01653: unable to extend table . by in tablespace (4232085)
(os errno 2) ... The reorg tablespace has insufficient tablespace. ... For example, suppose you have allocated 74G and you need one more gig. Oracle will create another extent, and it may be so large that the 90G tablespace runs out of space, even though you only needed one extra gig.
Unable to locate QSA manual installation files for Solaris 10 and Oracle 9. (4351819)
The file descriptions for QSA standalone installation seem to exclude the combination of Solaris 10 for Oracle 9. ... This is a documentation error and a request to update the download site has been created.
Analysis Job Stuck - status indicates 'running' but unable to reschedule (4235082)
User ran an analysis job and it completed with errors, however the job can't be rescheduled because the status indicates that it is still running ... RESOLUTION1:
How to use Live Reorg to reorg a table on the source in a High-Availability replication environm (4296563)
If a table is reorganized using Live Reorg, it will change the object id of the table. ... For this reason, one cannot reorganize a source table in a replicating environment. ... Using Live Reorg on secondary in a HA environment requires some considerations.
Recommendation on how to reorg a table with an xmltype (4255465)
You will need to install XDB schema. ... This is the manual method using catqm.sql: ... ============================================== ... After the database installation, you must run the following SQL scripts in rdbms/admin connecting to SYS to install Oracle XML DB after creating a new tablespace for Oracle XML DB Repository.
How To Install Space Manager with Live Reorg (4354273)
Space Manager with Live Reorg is a client/server application. ... The Space Manager GUI resides on the Windows client and a daemon, the Quest Server Agent (QSA) resides on the database server. ... Installation starts with the installation of Space Manager on the Windows client, and when a connection is made to a database, the GUI's database objects are created.
How To get the most from Quest Support when raising a case for Space Manager with Live Reorg (4353500)
What information do Quest Support need when raising a case for Space Manager with Live Reorg, and why do they need it? ... In order to speed resolution, when creating a case with Quest Support, ensure you supply the following version information; 1) Version of Space Manager you are using.
How to tidy up an aborted Space Manager (with Live Reorg) job. (4351759)
Online reorgs create objects in the database. ... Objects are created to manage the reorg, and new replacement objects for the existing objects are created. ... If an attempt is made to create a new script for a table that has not had a tidy up performed after an abort, Space Manager will display the message '<Table> will not be reorganized because it is a Space Manager work object or an object currently in another LiveReorg process or an object from a previous aborted LiveReorg'.
ORA-01555 snapshot too old during create table (4332929)
When select the option of "perform sorted reorg", there is "order by" for insert into table step, which caused the ORA-01555:snapshot too old error. ... Uncheck the "perform sorted reorg" and verify in the script the "order by" is not there.
Reorg aborts with AbortScript: Aborted ORA-00955: name is already used by an existing object (4353430)
This scenario can occur if a job is cancelled and restarted whilst an index is being built. ... This is a timing issue. ... If Oracle completes an index build before the cancellation of the job takes hold, QSA thinks the index build was cancelled when it actually did complete.
Generate script and resize tablespace in properties fails for dictionary not locally manage (4235195)
When user changes the properties for a tablespace (usually the size) and clicks on 'generate script' button, the resulting script says 'No property modification required'. ... This result only happens for dictionary tablespaces not locally managed tablespace.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All