Re: sysusers deleted

From: Florian <wizard_ozREMOVE_at_gmx.net>
Date: Fri, 07 Jan 2005 15:41:47 -0600
Message-ID: <1105134107.7d6046767ef92363dfefc6c823a26c4f@teranews>

Rauf Sarwar 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.

>
>
> What is your Oracle version. I don't see this object in 8i, 9i or 10g.
> Maybe it's something home grown by SYSTEM user.
>
> This is from 10g
> SQL> select object_name from all_objects
> 2 where upper(object_name) like '%SYSUSER%';
>
> OBJECT_NAME
> ------------------------------
>
>
> This is from 9i
> SQL> select object_name from all_objects
> 2 where upper(object_name) like '%SYSUSER%';
>
> OBJECT_NAME
> ------------------------------
>
>
> This is from 8i
> SQL> select object_name from all_objects
> 2 where upper(object_name) like '%SYSUSER%';
>
> OBJECT_NAME
> ------------------------------
>
> SQL>
>
> Do you take backups? Maybe next time you would pay attention while
> deleting stuff as sys or system.
>

Yes, I will be more careful. Thanks for letting me know, seems as if that table is not needed after all ... Received on Fri Jan 07 2005 - 15:41:47 CST