Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to run BeginDDL on a version enabled table on OWM 9.2.0.8

485046Jul 14 2009 — edited Jul 24 2009
Hello,

We running Oracle 9i with OWM 9.2.0.8

We are trying to run BeginDDL on a version enabled table with approx 2.8 million records
in it. And when we try running the statment:

BEGIN
DBMS_WM.BeginDDL('PFS_SPOT_SHOTS');
END;

We get the following error:

ORA-20203: enable/disable versioning or begin/commitDDL is being executed on PFSDB.PFS_SPOT_SHOTS
ORA-06512: at "WMSYS.OWM_DDL_PKG" line 3378
ORA-06512: at "WMSYS.LT", line 11827
ORA-06512: at line 2

We also try running BeginDDL on another version enabled table with no data in it

BEGIN
DBMS_WM.BeginDDL('PFS_DUMMY_POINT');
END;

then we are getting the following error:

ORA-25150: ALTERING of extent parameters not permitted
ORA-06512: at "WMSYS.OWM_DDL_PKG", line 3378
ORA-06512: at "WMSYS.LT", line 11827
ORA-06512: at line 2


Any suggestions in regards to this problem?

Thanks
Gary
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2009
Added on Jul 14 2009
5 comments
3,956 views