Versão do produto
Tópico
Live reorg fails with Oracle error "ORA-01652: unable to extend temp segment by 1093500 in tables (4352673)
The reorg log shows; [2928] 04/04 15:45:31 ORA-01652: unable to extend temp segment by 1093500 in tablespace PSAPTEMP ... [2928] 04/04 15:45:31 AbortScriptWithError() [2928] 04/04 15:45:31 AbortScript: Aborted ORA-01652: unable to extend temp segment by 1093500 in tablespace PSAPTEMP
How to Remove/Delete Analysis Job (4316524)
You cannot delete Analysis Job from the Scripts/Job Monitor by right clicking on the job and selecting delete . ... To remove an analysis group, right click on it in the Analysis Groups tab of the Explorer and choose Delete from a shortcut menu.
Locking problems with Live Reorg possibly extending switch times. (4354286)
During the execution of a Space manager script two brief exclusive locks are taken out against the table in order to obtain a synchronization point. ... The two places in the job are at the start of the table copy and at the start of the switch.
Oracle issue with exchange partition and clob columns (4352630)
A factor is if the table has CLOBs which are moved from out of row storage to in row storage. ... Before the exchange the tables are ok, but once the exchange has taken place, Oracle is unable to return the table in bulk to a select statement.
QSA-20392 errors during reorg, QSA 1.1c11 (4231025)
During reorg, users may come across with error: I was running a Traditional Reorg script that only had one table in it. ... I got the following error in the log file: ... 03/21 07:48:10 Open write fifo ../log/QUESTLR.Mar21_2004.032104_appst_into_po.ip c oserror=6
Error: "ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION" (4326266)
Error: "ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION" during online switch of table containing one or more RAW columns. ... When a database has been upgraded from Oracle 8i to 9, there is one column being referenced that is not updated in a table.
Error: "ORA-02294 Error while attempt to enable index constraint" (4327229)
When LiveReorg job is running, it encounters the error: "ORA-02294 cannot enable (Primary Key name) - constraint changed during validation". ... The job is then aborted, and cannot proceed. ... From the reorg log file:
ALTER TABLESPACE <name> COALESCE - not inserted into script. (4247745)
Some scripts contain the call to ALTER TABLESPACE<name></name>COALESCE and others do not, when the option to coalesce/check for freespace is selected. ... The ALTER TABLESPACE<name></name>COALESCE is not scripted when wait_for_freespace is scripted, because wait_for_freespace will make the coalesce call.
QSA Failed to Stop Error - QSA-20314 (4265317)
An attempt was made to stop QSA while one or more scripts were being executed<br>2. bequeath_datach is not set in Oracle sqlnet.ora file Resolution 1<br><br>Wait until all scripts have completed or cancel all scripts that are being executed.
ORA-20000: Gathering statistics for an index on temporary table is not supported (4352641)
An analysis job aborts with ORA-20000: Gathering statistics for an index on temporary table is not supported ... The analysis job has attempted to analyze an index on a temporary table. ... WORKAROUND:
Session failed: "ORA-14400: inserted partition key does not map partition" (4304839)
Session failed:ORA-14400: inserted partition key does not map partition. ... Partition table gets ORA-14400 because there are new partitions added. ... This occurs when Reorg fails due to new partitions added during reorg which were not present when script started.
Error "licensed number of Oracle servers has been exceeded" (4328739)
The following message shows on the screen: ... "licensed number of Oracle servers has been exceeded" when trying to connect via Space manager with livereorg GUI. ... Number of oracle servers being connected is more than the license limit.
Is Oracle Partitioning used by Space Management with Live Reorg? (4297180)
Why is only the T-lock switch style available? ... There are two types of switch methods in Live Reorganization : 1. ... T-lock switch ... The Online switch reorg method requires Oracle partitioning to be enabled and licensed on the database as the copy table created on a standard table will be partitioned.
Livereorg option disabled (4231764)
The option optimize for speed only allows redefinition, the Livereorg option is gray ... Here is the checklist for disabled Livereorg option: ... 1. The license key ( send the key you to support for verification) or check top left corner of space manager explorer for the words "Space Manager or Space Manager with Livereorg"
ORA-01452 cannot CREATE UNIQUE INDEX; duplicate keys found (4353376)
This has been seen when there was corruption in the table/index. ... Execute the command; SQL>analyze table <table_name> validate structure cascade; ... Any errors returned bt the analyze should be reported to Oracle for resolution.
QSA-20391 ORA-20777 during internal SQL (os errno 0) (4352721)
QSA is trying to query a sequence that it has created. ... Oracle bug 2217015 returns this error for a newly created sequence if SMON is busy when you query the sequence. ... This is an Oracle bug (number 2217015 ) which is found in databse version 8.1.7.
Do I need to run Update PS ObjectMover Instructions for every Stat patch during uprade process (4236891)
<p>I am upgrading my Stat database to the latest version and need to apply several different patches.
Does Space Manager support MainFrame? (4320746)
Can Space Manager be installed on Mainframe machine? ... Space Manager does not support Mainframe.
Locally Managed vs. Dictionary Managed Tablespaces - LiveReorg (4267501)
Is there any requirement for tablespaces to be locally managed to execute live reorgs, or is it okay to have either locally managed or dictionary managed tablespaces? ... Please note also that the product pre-dates LMT, so Dictionary managed tablespaces have always been supported.
Novalidate constraints script (4332542)
We are on QSA 6.2.0 version and the coresponding space manager version.<br>When performing live reorg of some tables it is giving a caution that table has novalidate constraints and those to be validated before running the reorg.
Install of QCO Agent fails on Error - ./quest_u.sh[64]: ../config/qexecd.conf: not found (4332554)
I have upgraded the SpaceMgr with Liveroerg from 6.7 to 7.0. ... Connect to database, run the following:<br>delete quest_com_products<br>where product_id = 61;<br>commit;<br>2. ... Make sure no qexecd process is running<br>3.
Cleanup option disabled (4328733)
The script was cancelled and even then the Cleanup option was disabled. ... The Agent's job scheduler could not detect when the script was cancelled or aborted. ... Stop and Start the agent to ensure that the change is recognized.
How can I clear the Connection History Entries? (4316496)
Space Manager fails to connect to the database due to the limited number of hosts listed in licensing information. ... If the licensing magnitude is limited to the number of servers, and hosts are recycled, Space Manager looks for the old hostname upon connection and it fails to connect the instance.
Associação de novos produtos
- Ferramentas de autoatendimento
- Base de conhecimento
- Notificações e alertas
- Suporte a produtos
- Downloads de software
- Documentação técnica
- Fóruns de usuário
- Tutorial em vídeo
- Feed RSS
- Fale conosco
- Suporte técnico
- Visualizar tudo