CDB* views missing LONG datatype columns

Discussion:

Ramnivas Chaurasia

2018-07-13 12:07:35 UTC

Hi,

Has anyone noticed that all the CDB* views are missing LONG datatype
columns from corresponding DBA* views? I wanted to check if it's expected.

I checked this on Oracle Database 12c Enterprise Edition Release
12.1.0.2.0 - 64bit Production.

Thanks,
Ramniwas

Franck Pachot

2018-07-13 12:50:13 UTC

Permalink

Hi Ramnivas,
Yes I noticed it. LONG do not pass the container barrier. I opened a SR and
this was not accepted as a bug because there is no godd mecanism to do it.
for this.This means that you cannot see view definition for common objects
when you are in a container.
Regards,
Franck.

On Fri, Jul 13, 2018 at 2:08 PM Ramnivas Chaurasia <

Post by Ramnivas Chaurasia
Hi,
Has anyone noticed that all the CDB* views are missing LONG datatype
columns from corresponding DBA* views? I wanted to check if it's expected.
I checked this on Oracle Database 12c Enterprise Edition Release
12.1.0.2.0 - 64bit Production.
Thanks,
Ramniwas

John Mchugh

2018-07-13 18:37:16 UTC

Permalink

Hi Ramniwas,

Not sure I understand the response in the SR, but LONG Columns deprecation notice <https://docs.oracle.com/cd/A91202_01/901_doc/server.901/a90120/ch4_dep.htm#6690> was in 9.0.1. It is not widely used but certain dictionary views (DBA*)
still use it. It is not supported in cross container dictionary views (CDB*).

thx
jpm

Post by Franck Pachot
Hi Ramnivas,
Yes I noticed it. LONG do not pass the container barrier. I opened a SR and this was not accepted as a bug because there is no godd mecanism to do it.
for this.This means that you cannot see view definition for common objects when you are in a container.
Regards,
Franck.
Hi,
Has anyone noticed that all the CDB* views are missing LONG datatype columns from corresponding DBA* views? I wanted to check if it's expected.
I checked this on Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production.
Thanks,
Ramniwas

Ramnivas Chaurasia

2018-07-14 13:46:27 UTC

Permalink

Since Oracle is still maintaining LONG data type for their dictionary
views, it's a little disappointing not being able to get the same data view
via CDB* views.

Thanks,
Ramniwas

Post by John Mchugh
Hi Ramniwas,
Not sure I understand the response in the SR, but LONG Columns
deprecation notice
<https://docs.oracle.com/cd/A91202_01/901_doc/server.901/a90120/ch4_dep.htm#6690> was
in 9.0.1. It is not widely used but certain dictionary views (DBA*)
still use it. It is not supported in cross container dictionary views (CDB*).
thx
jpm
Hi Ramnivas,
Yes I noticed it. LONG do not pass the container barrier. I opened a
SR and this was not accepted as a bug because there is no godd mecanism to
do it.
for this.This means that you cannot see view definition for common objects
when you are in a container.
Regards,
Franck.
On Fri, Jul 13, 2018 at 2:08 PM Ramnivas Chaurasia <

Andy Sayer

2018-07-14 21:05:44 UTC

Permalink

With the example of _Views, there exists a text_vc column which projects
the text column as a varchar2(4000) albeit limited to the first 4000
characters. This column is available in cdb_views.

The only other current examples are %_constraints.search_condition and
%_views_ae.text_vc. Hopefully. we'll get solutions for the other 28 columns
in the future.

Post by Ramnivas Chaurasia
Since Oracle is still maintaining LONG data type for their dictionary
views, it's a little disappointing not being able to get the same data view
via CDB* views.
Thanks,
Ramniwas

Post by John Mchugh
Hi Ramniwas,
Not sure I understand the response in the SR, but LONG Columns
deprecation notice
<https://docs.oracle.com/cd/A91202_01/901_doc/server.901/a90120/ch4_dep.htm#6690> was
in 9.0.1. It is not widely used but certain dictionary views (DBA*)
still use it. It is not supported in cross container dictionary views (CDB*).
thx
jpm
Hi Ramnivas,
Yes I noticed it. LONG do not pass the container barrier. I opened a
SR and this was not accepted as a bug because there is no godd mecanism to
do it.
for this.This means that you cannot see view definition for common
objects when you are in a container.
Regards,
Franck.
On Fri, Jul 13, 2018 at 2:08 PM Ramnivas Chaurasia <