Re: CDB* views missing LONG datatype columns

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.

On 14 July 2018 at 14:46, Ramnivas Chaurasia <ramnivaschaurasia_at_gmail.com> wrote:

> 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