Re: sysusers deleted

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 Received on Fri Jan 07 2005 - 12:42:00 CST