Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Another curiosity . . .
select * from dba_synonyms where table_name like '%MODIFICATIONS%'
"TurkBear" <john.greco_at_dot.state.mn.us> a écrit dans le message news:
6neh6vgt9icn1trb4i7v401ndckai9kfh2_at_4ax.com...
>
> And you know this how? --
> "EpiteamB" <carmanetREM_at_epicentre.fr> wrote:
>
> >problem of privileges, or synonym does not exist on the
> >DBA_TAB_MODIFICATIONS
> >view...
> >
> >Céline.
> >
> >"Ed Stevens" <nospam_at_noway.nohow> a écrit dans le message news:
> >3clf6v0o3p4pg7qgk8507stmrt8kac5utr_at_4ax.com...
> >> Oracle 8.1.7
> >>
> >> Check this short session transcript. Why can I select from DBA_VIEWS,
> >> but not DBA_TAB_MODIFICATIONS?
> >>
> >> SQL> connect system/****
> >> Connected.
> >> SQL> select view_name from dba_views where view_name like '%TAB_MOD%';
> >>
> >> VIEW_NAME
> >> ------------------------------
> >> ALL_TAB_MODIFICATIONS
> >> DBA_TAB_MODIFICATIONS
> >> USER_TAB_MODIFICATIONS
> >>
> >> SQL> desc DBA_TAB_MODIFICATIONS
> >> ERROR:
> >> ORA-04043: object DBA_TAB_MODIFICATIONS does not exist
> >>
> >>
> >> SQL> desc sys.dba_tab_modifications
> >> Name Null? Type
> >> ----------------------------------------- --------
> >> --------------------
> >> TABLE_OWNER VARCHAR2(30)
> >> TABLE_NAME VARCHAR2(30)
> >> PARTITION_NAME VARCHAR2(30)
> >> SUBPARTITION_NAME VARCHAR2(30)
> >> INSERTS NUMBER
> >> UPDATES NUMBER
> >> DELETES NUMBER
> >> TIMESTAMP DATE
> >> TRUNCATED VARCHAR2(3)
> >>
> >> SQL> select owner, view_name from dba_views where
> >> view_name='DBA_VIEWS';
> >>
> >> OWNER VIEW_NAME
> >> ------------------------------ ------------------------------
> >> SYS DBA_VIEWS
> >>
> >> SQL>
> >
>
Received on Mon Mar 10 2003 - 05:21:35 CST