Re: sysusers deleted

From: Florian <wizard_ozREMOVE_at_gmx.net>
Date: Fri, 07 Jan 2005 15:39:28 -0600
Message-ID: <1105133969.52e5f9abcb11361318c062eb063d3b92@teranews>

fitzjarrell_at_cox.net wrote:
> Florian wrote:
>

>>Hi,
>>
>>I accidentally deleted the SYSTEM.SYSUSERS table, I was clicking to
>>delete a TEST table but I was too quick !!
>>
>>It's only a test server used for development, but reinstalling would
>>still be quite a pain.
>>
>>So far everything is still working (login etc.), so I'm not sure what

>
>

>>bad I did - but I figured that table has to be good for something?
>>
>>Can somebody tell me how to recreate that table? Or can I ignore that

>
>

>>table and just keep on working?
>>
>>
>>Thanks.

>
>
> SYSUSERS is not an object in either 9i or 10g, and I don't remember
> seeing it in 8i, either. It appears to be some 'homegrown' addition,
> possibly by someone more familiar with Sybase or SQL Server than
> Oracle. This may also be a table some application has installed (some
> like to use the SYSTEM tablespace for their objects, much to the
> chagrin and dismay of the DBA); you may want to check if any
> applications are failing due to its absence. It is not necessary for
> Oracle to function, as it is not part of the data dictionary.
>
> Ask around and see who may have created it. And possibly be a bit more
> selective with your mouse next time.
>
> David Fitzjarrell
>

Thanks, I don't know how it got in there. So far I have only used the Oracle 9i software and nothing else. Oh well, as long as I don't need it I'm happy.

Thank you! Received on Fri Jan 07 2005 - 15:39:28 CST