Re: CDB* views missing LONG datatype columns

From: Ramnivas Chaurasia <ramnivaschaurasia_at_gmail.com>
Date: Sat, 14 Jul 2018 19:16:27 +0530
Message-ID: <CAGwus2UzYZxTsi6q72HcjcRGgbkMOthms8Yby_LEK0QZNttkow_at_mail.gmail.com>



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

On Sat, Jul 14, 2018 at 12:07 AM, John Mchugh <john.mchugh_at_oracle.com> wrote:

> 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> 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
Received on Sat Jul 14 2018 - 15:46:27 CEST

Original text of this message