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@xxxxxxxxxx> 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@xxxxxxxxx <mailto:ramnivaschaurasia@xxxxxxxxx>> 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