You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by Oleksandr Diachenko <od...@hortonworks.com> on 2014/01/24 17:07:51 UTC
Review Request 17316: During Oracle schema upgrade ORA-06502: PL/SQL:
numeric or value error: raw variable length too long
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17316/
-----------------------------------------------------------
Review request for Ambari, Myroslav Papirkovskyy and Sid Wagle.
Repository: ambari
Description
-------
Changes was made in script Ambari-DDL-Oracle-UPGRADE.sql:
- Update statement that fills table column "stage.cluster_host_info" was changed to deal with long commands.
- Analytical function "ROW_NUMBER" was added to handle duplicates.
- New function was added: "compress_cluster_host_info_pkg.substr_blob" - it is similar to "dbms_lob.substr", but has no limitation in a maximum buffer size of 2000 bytes.
- Fixed using of correct type nested_vachar2_tbl_type.
Diffs
-----
ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Oracle-UPGRADE.sql 53b2b7a
Diff: https://reviews.apache.org/r/17316/diff/
Testing
-------
Thanks,
Oleksandr Diachenko
Re: Review Request 17316: During Oracle schema upgrade ORA-06502: PL/SQL:
numeric or value error: raw variable length too long
Posted by Oleksandr Diachenko <od...@hortonworks.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/17316/
-----------------------------------------------------------
(Updated Jan. 24, 2014, 4:14 p.m.)
Review request for Ambari, Myroslav Papirkovskyy and Sid Wagle.
Bugs: https://issues.apache.org/jira/browse/AMBARI-4415
https://issues.apache.org/jira/browse/https://issues.apache.org/jira/browse/AMBARI-4415
Repository: ambari
Description
-------
Changes was made in script Ambari-DDL-Oracle-UPGRADE.sql:
- Update statement that fills table column "stage.cluster_host_info" was changed to deal with long commands.
- Analytical function "ROW_NUMBER" was added to handle duplicates.
- New function was added: "compress_cluster_host_info_pkg.substr_blob" - it is similar to "dbms_lob.substr", but has no limitation in a maximum buffer size of 2000 bytes.
- Fixed using of correct type nested_vachar2_tbl_type.
Diffs
-----
ambari-server/src/main/resources/upgrade/ddl/Ambari-DDL-Oracle-UPGRADE.sql 53b2b7a
Diff: https://reviews.apache.org/r/17316/diff/
Testing
-------
Thanks,
Oleksandr Diachenko