Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Darn invalid objects dependencies!

Re: Darn invalid objects dependencies!

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 15 Oct 2001 08:54:44 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7105B59@lnewton.leeds.lfs.co.uk>

-----Original Message-----
From: Thomas Kyte [mailto:tkyte_at_us.oracle.com] Posted At: Saturday, October 13, 2001 2:28 PM Posted To: server
Conversation: Darn invalid objects dependencies! Subject: Re: Darn invalid objects dependencies!

>> The first execution should just
>> specify the schema name and the second should set the "compile_all"
flag to
>> FALSE.
SQL> exec dbms_utility.compile_schema(
'SCHEMA_NAME_YOU_WANT_TO_COMPILE', FALSE); Hi Thomas,

I've just tried this out - and it works, but in the docs for 8.1.7, there is no mention of the second parameter, so thanks for that little 'insider' bit of information. I know it doesn't work on 8.0.5, but I'm off to test out 8.1.5 now :o)

Cheers,
Norman.



Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com
------------------------------------------------------------------------

Received on Mon Oct 15 2001 - 02:54:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US