Re: DBSNMP database user schema recreation

From: <attwoody_at_my-dejanews.com>
Date: Tue, 18 May 1999 19:49:19 GMT
Message-ID: <7hsg7u$mpe$1@nnrp1.deja.com>

In article <7hn37q$v19$1_at_antiochus.ultra.net>, "Eugene Firyago" <efiryago_at_bisys.com> wrote:
> Does anybody know how to recreate DBSNMP database user schema in case
> the DBSNMP database user has been dropped by
> mistake (with cascade option). The database was operating in
> NOARCHIVELOG mode and there were no backups made
> for this database. The database recreation itself is not an acceptable
> idea...sorry...
>
> Thanks in advance,
> Eugene.
>
>

Greetings, Eugene,

I've never seen this user own any tables (probably because I'm not running any utilities or software that use it), but if you want to re-create DBSNMP with all its access privileges and synonyms, you can re-run the 'catsnmp.sql' in your $ORACLE_HOME/rdbms/admin directory (on UNIX; don't know the location on NT) script.

Take care

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 18 1999 - 14:49:19 CDT