Re: CDB* views missing LONG datatype columns

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

> On Jul 13, 2018, at 5:50 AM, Franck Pachot <franck_at_pachot.net> wrote:
>
> 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 <ramnivaschaurasia_at_gmail.com <mailto:ramnivaschaurasia_at_gmail.com>> wrote:
> 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

--
http://www.freelists.org/webpage/oracle-l