The Reorg failed with the following error
...
...
[258] 04/18 13:47:58 line=1362 sql=CREATE TABLE SCOTT.QUEST_SPC_TMP_41328_LRTAB (
...
COL_ONE NUMBER(15) DEFAULT 0 NULL,
COL_TWO NUMBER(15) DEFAULT 0 -- ¸ÅöÝ NULL,
COL_THREE CHAR(9 BYTE) DEFAULT NULL,
COL_FOUR NUMBER(1) DEFAULT 0 NULL,
COL_FIVE NUMBER(15,4) DEFAULT 0 NULL,
...
...
[258] 04/18 13:47:58 ORA-00907: missing right parenthesis
[258] 04/18 13:47:58 AbortScriptWithError()
[258] 04/18 13:47:58 AbortScript: Aborted ORA-00907: missing right parenthesis
(os errno 2) (other error -907)
This is due to a bug in script generation where a table was created with an Oracle comment in the default expression for a column. e.g.
create table mytable (unique_id number
default 100 -- comment here
not null) ;
Quest Server Agent (QSA) will read the create table from the quest_script table and then execute it as an SQL statement. QSA does not parse or alter the statement, it will just pass it to Oracle and Oracle will execute it.
WORKAROUND
None
RESOLUTION
Issue is fixed in version 6.8. The latest version of Space Manager with LiveReorg can be downloaded at:
http://support.quest.com/support_download/Downloads.asp
