Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

DBA_USER_COMMENTS and comments on schema

David Luis Moya GarridoMay 12 2015 — edited Jan 11 2016

Hello,

why does not  exist DBA_USER_COMMENTS ? so, you can not add comment to a SCHEMA.

You can comment on table, column,operator,indextype and mview, but you can not comment a schema....

EXAMPLE :

Comment on SCOTT is 'User blocked by LAW until 2018';

sql> select user,comments from DBA_USER_COMMENTS where USER='SCOTT';

SCOTT User blocked by LAW until 2018

This feature will help to schemas maintenance

Regards.

Comments
Post Details
Added on May 12 2015
7 comments
1,106 views