지금 지원 담당자와 채팅
지원 담당자와 채팅

Live-Reorg - 기술 문서 검색

Filter Your Results

제품 버전

항목

Filter Search Results

키워드별 검색 기술 문서

(다른 제품 선택)



DateRelevanceViews 표시 1-25 / 48
Proper Rollback Sizing for Live Reorg (4269782)

If the rollback segments are not properly sized, then the live reorg will not succeed. ... To determine how large rollback segments should be for a Live reorganization, estimate how long it will ta...

제품: Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 339 보기
Knowledge Article
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 ensu...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 768 보기
Knowledge Article
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 ...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 737 보기
Knowledge Article
Does Index need to be recreated in Standard Reorg? (4325080)

In standard reorg if the script fails after dropping indexes what needs to be done? ... In standard reorg Indexes are dropped in the beginning, so if the script fails after dropping the indexes tha...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 408 보기
Knowledge Article
ORA-600 detected in : ORA--00603 followed by ORA-01114 and ORA-27063 (4232770)

reorg fails with ora-600 followed by errors in the trace file indicating corrupt disc or writing error. ... On an Solaris platform you may see an error message like: ... Specifically, the high numb...

제품: Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 463 보기
Knowledge Article
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 val...

제품: Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 174 보기
Knowledge Article
Does Space Manager support MainFrame? (4320746)

Can Space Manager be installed on Mainframe machine? ... Space Manager does not support Mainframe.

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 132 보기
Knowledge Article
Switch rac nodes between clusters - becomes unstable to connect (4236367)

You need to clean up the old QSA and reinstall. ... The shortest way to do that if there is no QSA version changed between the old and the new is to force a fresh install. ... Run the query below a...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 396 보기
Knowledge Article
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 qex...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 631 보기
Knowledge Article
Live Reorg unable to connect to database to install database objects during install. (4269774)

Live-Reorg<br>Live Reorg unable to connect to database to install database objects during install.

제품: Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 192 보기
Knowledge Article
Does QSA support Oracle 11g? (4325043)

11g is not a supported version at this moment. ... STATUS: ... It will be supported in the future release. ... It is available as private beta for Windows and Linux platform.

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 222 보기
Knowledge Article
Workaround to QSA 6.2 against Oracle 9.2.0.4 and earlier on AIX 5 (4326238)

Error: "QSA-20383: Could not create configuration file" when trying to install Quest Server Agent on Oracle pre 9205 running on AIX. ... Workaround to support QSA 6.2 against pre Oracle 9.2.0.5 on ...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 221 보기
Knowledge Article
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 o...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 549 보기
Knowledge Article
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 r...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 370 보기
Knowledge Article
ALTER TABLESPACE &lt;name&gt; 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 ...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 321 보기
Knowledge Article
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 ...

제품: Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 120 보기
Knowledge Article
Is it possible to use Space Manager with LiveReorg with an Operating System version that is lower than the one specified in System Requirement? (4299997)

<p>It is possible to do so as QSA is backward compatible when it comes to Operating System. ... For example, the Space Manager with LiveReorg version 8.5 is stated to be compatible with Solaris 11 ...

제품: Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 813 보기
Knowledge Article
Received: you must be the original installing user in order to perform the upgrade. (4260288)

This version of Space Manager with LiveReorg requires an upgrade to the database objects on abc instance. ... However, you must be the original installing user in order to perform the upgrade. ... ...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 168 보기
Knowledge Article
Live reorg fails with Oracle error "ORA-01652: unable to extend temp segment by 1093500 in tables (4352673)

During the reorg the named tablespace has run out of space. ... Increase the free space in the tablespace and resume the job. ... If more space is not available, the job will need to be cleaned up.

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 695 보기
Knowledge Article
Error: "Aborted- qsa 20392 internal error-cleanup trigger locks too after cancelled reorg." (4236075)

This error is received seconds after restarting a cancelled reorg: Restart for table type TABLE ... Original for PRSNL.5101601637, job 53 requires object ID validation for restart ... Error retriev...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 332 보기
Knowledge Article
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...

제품: Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 203 보기
Knowledge Article
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.

제품: Toad Data Modeler, Space Manager with LiveReorg, Stat, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 318 보기
Knowledge Article
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 fo...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 528 보기
Knowledge Article
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 ...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 646 보기
Knowledge Article
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. ... WORKARO...

제품: Space Manager with LiveReorg, Live-Reorg
최종 업데이트 날짜: 2023-05-07
NA rating | 264 보기
Knowledge Article
모든 제품 검색
권장 콘텐츠
Updating results
셀프 서비스 도구
지식 기반
공지 및 알림
제품 지원
소프트웨어 다운로드
기술 설명서
사용자 포럼
비디오 자습서
RSS 피드
문의처
기술 지원
모두 보기