Re: Invalid View - after Full Import

From: <Winnie_Liu_at_infonet.com>
Date: Fri, 28 Apr 2000 11:36:22 -0700
Message-Id: <10481.104465@fatcity.com>

Have you look into the view and see where is the error coming from?

If the view is not compiled by
alter view <viewname> compile;

that tell you something is wrong in that view.

Winnie

glen.bernas_at_marchFIRST.com on 04/28/2000 10:29:15 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: Invalid View - after Full Import

To: ORACLE-L_at_fatcity.com
cc:

How do you repair a view after a Full import?

I ran sripts to repair the invalid objects after the import and the only one
not to recompile was one view.

I ran the script a number of times.

Thank in advance

---

Glen R. Bernas
Oracle DBA
Boston, MA
www.marchFIRST.com
glen.bernas_at_marchFIRST.com

Cell:  603 315-9380
Work:  603 890-1703 x 257
       800 426-7767

--
Author:
  INET: glen.bernas_at_marchFIRST.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_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).

Received on Fri Apr 28 2000 - 13:36:22 CDT