重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE [打印本页]

作者: admin    时间: 2016-9-6 19:50
标题: ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE
ORA-31496: must use DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE to drop
change tables
Cause:
An attempt was madeto use the SQL command DROP TABLE for change
tables, but DROP TABLE is not supported for change tables.
Action: Use theDBMS_CDC_PUBLISH.DROP_CHANGE_TABLE procedure
instead of the DROP TABLE command.
ORA-31497: invalidvalue specified for first_scn
Cause:
The first_scn was notgreater than zero or was less than the previous value
of first_scn.
Action: Check the value offirst_scn. Correct it to make sure it is an integer greater
than zero and greater than any previous value for this change source.
ORA-31498:description and remove_description cannot both be specified
Cause:
The description andremove_description parameters were both specified.
Action: Check the values ofdescription and remove_description. Correct call to
only supply one of these values.
ORA-31499: null valuespecified for required parameter string
Cause





欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2