From chuan@asiaonline.net Thu, 15 Mar 2001 21:57:54 -0800 From: "Chuan Zhang" Date: Thu, 15 Mar 2001 21:57:54 -0800 Subject: Re: how to compile the object type in oracle 8i Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, Mala, I had exactly this problem before in Oracle 8.0.6. I corrected it simply issue "alter type PQ$_DEQUEUE_HISTORY compile". I don't know what caused this problem happended. Pls let me know your implementation result. Chuan, ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Thursday, March 08, 2001 2:55 AM > Hi gurus > I found that one of objects has status INVALID. > The following are the output. > OWNER OBJECT_NAME OBJECT_TYP STATUS > ------ -------------------- ---------- ------- > SYS PQ$_DEQUEUE_HISTORY_T TYPE INVALID > How to correct this object. > Please advice me. > Thanks. > -Mala > > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: mala singh > INET: mala_singhm@hotmail.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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.com -- Author: Chuan Zhang INET: chuan@asiaonline.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).