Database Software

Hi

I'm playing right now in a schema with the workspace manager. In order to gather some timing of some sql before and after the versionnign of some tables, I asked

Yesterday I asked to have the my schema wipe and restore with the original version. The DBA did a drop user and then import the data back (import fromuser).

This morning, I tried to do my versionning and it failed saying that the table was already in this mode. I tried to disable the versionning and it failed also. I think I have a sync problem now between my wmsys schema and the schema with my table.

SQL> execute DBMS_WM.ENABLEVersioning ('DE_PTD_VALEUR_HORR','VIEW_WO_OVERWRITE');
BEGIN DBMS_WM.ENABLEVersioning ('DE_PTD_VALEUR_HORR','VIEW_WO_OVERWRITE'); END;

*
ERREUR à la ligne 1 :
ORA-20131: table 'DEORA1A.DE_PTD_VALEUR_HORR' is already version enabled
ORA-06512: at "SYS.LTDDL", line 457
ORA-06512: at "SYS.LTDDL", line 1123
ORA-06512: at "SYS.LTDDL", line 1107
ORA-06512: at "SYS.LT", line 9024
ORA-06512: at line 1


Ecoulé : 00 :00 :00.09
SQL> execute DBMS_WM.disableVersioning ('DE_PTD_VALEUR_HORR');
BEGIN DBMS_WM.disableVersioning ('DE_PTD_VALEUR_HORR'); END;

*
ERREUR à la ligne 1 :
ORA-00942: table or view does not exist
ORA-06512: at "SYS.LT", line 9152
ORA-06512: at line 1


Ecoulé : 00 :00 :00.95

Can i fix this easily without restoring the whole database?

Daniel