Views Are Not Getting Created And Multi DB Script Is Failing

(Doc ID 1574697.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.
***Checked for relevance on 14-Jul-15***


View creation is failing while running script.

By changing the buffer limit in $PIN_HOME/sys/dm_oracle/data/create_md_secondary_schema_view.source from dbms_output.enable(10000) to dbms_output.enable(), the issue has been resolved.

Is it recommended to do the same?


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms