RE: alter system

This is because materialized view logs do not appear in sys.obj$, which the dba_objects view is based on.

The logs appear in sys.mlog$, which the dba_snapshot_logs view is based on.

If you had checked dba_snapshot_logs you would have seen it. This is where OEM found it.

See catalog.sql and catsnap.sql

Jared

On Fri, 2003-10-03 at 09:29, Chris Stephens wrote:
> Thank You!!!
>
> Found this in the trace file....
>
> ORA-00942: table or view does not exist
> Current SQL statement for this session:
> INSERT INTO "SBC_GLOBAL"."MLOG$_EMPLOYEE_ROLE"
> (dmltype$$,old_new$$,snaptime$$,c
> hange_vector$$) VALUES
> (:d,:o,to_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:
> SS'),:c)
>
> ...I looked then proceeded to query all_objects....
>
> SQL> select object_name, object_type from all_objects where object_name like
> '%MLOG%';
>
> OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------
> C_MLOG# CLUSTER
> I_MLOG# INDEX
> MLOG$ TABLE
> MLOG_REFCOL$ TABLE
> I_MLOG_REFCOL1 INDEX
> MLOG$_ACTION TABLE
>
> ....didn't show up there. ???
>
> so I got into OEM and looked under snapshot logs and sure enough it was
> there.
>
> ...so I dropped it through OEM and the error disappeared.
> ...so I guess OEM is good for something!!
>
> But...why didn't the MLOG$_EMPLOYEE_ROLE not show up in all_objects (or
> dba_objects) but it did in OEM? ...and what tells Oracle to update that
> snapshot log? ..where is that information stored?
>
> Thanks for your help!!!...and everyone's help for that matter!
>
>
> chris
>
> -----Original Message-----
> Sent: Friday, October 03, 2003 10:11 AM
> To: Chris Stephens
>
> Then, you have to use oradebug.
>
> It goes like this:
> oradebug setmypid
> oradebug event 942 trace name errorstack forever, level 10
>
> You MUST be connected as sysdba in order to use oradebug. It may be
> platform/version specific problem.
>
> On Fri, 2003-10-03 at 11:08, Chris Stephens wrote:
> > Dedicated server.
> >
> > -----Original Message-----
> > From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
> > Sent: Friday, October 03, 2003 10:04 AM
> > To: Chris Stephens
> > Subject: RE: alter system
> >
> > Are you using a dedicated server connection or MTS?
> > On Fri, 2003-10-03 at 10:59, Chris Stephens wrote:
> > > I was connected as sysdba.
> > >
> > > ...after I first tried it as the object owner and received an
> insufficient
> > > privileges message.
> > >
> > > Any other ideas?
> > >
> > > Thanks for your help.
> > >
> > > -----Original Message-----
> > > From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
> > > Sent: Friday, October 03, 2003 9:47 AM
> > > To: Chris Stephens
> > > Subject: alter system
> > >
> > > Chris, you might need a SYSDBA connection to do that and
> > > and it must be a dedicated one.
> > >
> > >
> > >
> > >
> > > Note:
> > > This message is for the named person's use only. It may contain
> > > confidential, proprietary or legally privileged information. No
> > > confidentiality or privilege is waived or lost by any mistransmission.
> If
> > > you receive this message in error, please immediately delete it and all
> > > copies of it from your system, destroy any hard copies of it and notify
> > the
> > > sender. You must not, directly or indirectly, use, disclose,
> distribute,
> > > print, or copy any part of this message if you are not the intended
> > > recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> > > right to monitor all e-mail communications through its networks.
> > > Any views expressed in this message are those of the individual sender,
> > > except where the message states otherwise and the sender is authorized
> to
> > > state them to be the views of any such entity.
> >
> >
> >
> >
> > Note:
> > This message is for the named person's use only. It may contain
> > confidential, proprietary or legally privileged information. No
> > confidentiality or privilege is waived or lost by any mistransmission. If
> > you receive this message in error, please immediately delete it and all
> > copies of it from your system, destroy any hard copies of it and notify
> the
> > sender. You must not, directly or indirectly, use, disclose, distribute,
> > print, or copy any part of this message if you are not the intended
> > recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> > right to monitor all e-mail communications through its networks.
> > Any views expressed in this message are those of the individual sender,
> > except where the message states otherwise and the sender is authorized to
> > state them to be the views of any such entity.
>
>
>
>
> Note:
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mistransmission. If
> you receive this message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies of it and notify the
> sender. You must not, directly or indirectly, use, disclose, distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries each reserve the
> right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorized to
> state them to be the views of any such entity.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chris Stephens
> INET: ChrisStephens_at_affina.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).