Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table fedcommusr.md_commtab1 sharing=metadata
- (deptno number, dname varchar2(100));
- insert into fedcommusr.md_commtab1 values (1, 'One');
- insert into fedcommusr.md_commtab1 values (2, 'Two');
- comment on column fedcommusr.md_commtab1.deptno is 'department number';
- comment on column fedcommusr.md_commtab1.dname is 'Department name is';
- exec DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'FEDCOMMUSR');
- select owner,table_name, NUM_ROWS from dba_tables where owner like upper('%fed%') ;
- FEDCOMMUSR MD_COMMTAB1 (null)
Add Comment
Please, Sign In to add comment