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: URGENT: can't recreate the dictionary

Re: URGENT: can't recreate the dictionary

From: Yago <yago2003_at_terra.es>
Date: Tue, 13 May 2003 18:17:45 GMT
Message-ID: <dFawa.771551$0M1.813249@telenews.teleline.es>


Anyway, you should know that by executing catproc you are re-creating the db dictionary VIEWS (v$, gv$, and so on), but not the dictionary tables themselves. You only create the dictionary tables when executing a create database sentence.

Regards,
Yago

"Peter van Rijn" <p.vanrijnRM_at_THISzhew.nl> wrote in message news:vc1m2qi3fln5ff_at_corp.supernews.com...
> The LBACSYS user belongs to Oracle Label Security. If you did not mean to
> install/use it, you should de-install it. Refer to Note 233110.1 on
> Metalink.
>
> regards,
> Peter
>
>
> "Kamal" <kamal80_at_virgilio.it> schreef in bericht
> news:4e766a02.0305130324.798d55cd_at_posting.google.com...
> > Oracle 9.2.0.1.0 on Tru64.
> >
> > SQL> @/oracle/home92/rdbms/admin/catalog
> > create or replace
> > *
> > ERROR at line 1:
> > ORA-04045: errors during recompilation/revalidation of
> > LBACSYS.LBAC$AFTER_CREATE
> > ORA-00060: deadlock detected while waiting for resource
> >
> > And 1.3 Mb of log and errors.
> > I was connected as sys and no other user was connected.
> >
> >
> > Could anyone please help me? It is quite urgent.
> >
> >
> > Kamal
>
>
Received on Tue May 13 2003 - 13:17:45 CDT

Original text of this message

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