Database Software

Hi,

We are running OWM v9.2.0.1 and I had enabled versioning on all the tables (~200) in my schema.

All was fine until I had to make some major structure changes to the tables. I tried to make all the changes using dbms_wm.beginddl...then the mod...then dbms_wm.commitddl. Most of the changes were fine, but where I was getting into problems was changing the FK constraints. I would begin DDL on the parent, then the child, do the ALTER TABLE statement, then commit DDL on the child, then the parent. Even though my table names are a max of 22 characters, the PK index and constraint name is table_name_PK (making a max of 25 chars). One of the things that happens when doing the alter table is that OWM changes the PK to table_name_PKI$ making the key now 27 characters. I then get an error message stating that the max length is 26 chars. I rolled back the changes (or at least I tried to) and decided to disable versioning on all the tables. No problem, for all but one table.

I have tried everything I can think of to get versioning on this one table disabled, but I am stumped.

permit@devdb> exec dbms_wm.disableversioning('SITE_REQUEST_PROCESS', ignore_last_error=>TRUE) ;
BEGIN dbms_wm.disableversioning('SITE_REQUEST_PROCESS', ignore_last_error=>TRUE) ; END;

*
ERROR at line 1:
ORA-20104: cannot version disable this table
ORA-06512: at "SYS.LTDDL", line 831
ORA-06512: at "SYS.LTDDL", line 1663
ORA-06512: at "SYS.LTDDL", line 1648
ORA-06512: at "SYS.LT", line 8116
ORA-06512: at line 1


permit@devdb> exec dbms_wm.disableversioning('SITE_REQUEST_PROCESS', ignore_last_error=>TRUE) ;
BEGIN dbms_wm.disableversioning('SITE_REQUEST_PROCESS', ignore_last_error=>TRUE) ; END;

*
ERROR at line 1:
ORA-20104: cannot version disable this table
ORA-06512: at "SYS.LTDDL", line 831
ORA-06512: at "SYS.LTDDL", line 1663
ORA-06512: at "SYS.LTDDL", line 1648
ORA-06512: at "SYS.LT", line 8116
ORA-06512: at line 1


permit@devdb> select * from all_wm_versioned_tables;

TABLE_NAME OWNER STATE
------------------------------ ------------------------------ -------------
HISTORY NOT
-------------------------------------------------- ---
NOTIFYWORKSPACES
----------------------------------------------------------------------------------------------------
CONFLICT
----------------------------------------------------------------------------------------------------
DIFF
----------------------------------------------------------------------------------------------------
SITE_REQUEST_PROCESS PERMIT VERSIONED
VIEW_WO_OVERWRITE NO

NO
NO


permit@devdb>

Help please!


...Dave Kent