Message-Id: <10659.120101@fatcity.com> From: "Tom Pall" Date: Tue, 24 Oct 2000 15:57:08 -0500 Subject: Re: MDSYS user This is a multi-part message in MIME format. ------=_NextPart_000_029D_01C03DD3.10606340 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MDSYS userMTSSYS rdbms\admin\oramts.sql (this is for MTS use)=20 CTXSYS ctx\admin\dr0csys.sql (this is for intermedia)=20 MDSYS,ORDPLUGINS,ORDSYS ord\admin\ordisys.sql (for intermedia)=20 OUTLN rdbms\admin\sql.bsq (for sql execution plans)=20 ----- Original Message -----=20 From: Yttri, Lisa=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, October 24, 2000 2:31 PM Subject: MDSYS user Hi -=20 Can someone explain to me what the MDSYS user is needed for? On = reviewing invalid objects, I noticed that this user has several views = marked as invalid? I'm trying to figure out what to do about it. Thanks -=20 Lisa=20 ------=_NextPart_000_029D_01C03DD3.10606340 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MDSYS user
MTSSYS rdbms\admin\oramts.sql (this is for MTS use) =
CTXSYS=20 ctx\admin\dr0csys.sql (this is for intermedia) =
MDSYS,ORDPLUGINS,ORDSYS=20 ord\admin\ordisys.sql (for intermedia)
OUTLN rdbms\admin\sql.bsq = (for sql=20 execution plans)

----- Original Message -----
From:=20 Yttri, Lisa=20
To: Multiple recipients of list ORACLE-L =
Sent: Tuesday, October 24, 2000 = 2:31=20 PM
Subject: MDSYS user

Hi -

Can someone explain to me what the MDSYS user is = needed=20 for?  On reviewing invalid objects, I noticed that this user has = several=20 views marked as invalid?  I'm trying to figure out what to do = about=20 it.

Thanks -
Lisa=20