Matthias Hoys wrote:
> <fitzjarrell_at_cox.net> wrote in message
> news:1105123320.342465.215170_at_f14g2000cwb.googlegroups.com...
>
>>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
>>
>
>
> sysusers is definitely an SQL Server system table.
>
> Matthias
So now the confusion. Is this the result of someone posting in the
wrong usenet group or a very bad port of a SQL Server/Sybase app to
Oracle. We shall have to await the OP's response.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Received on Fri Jan 07 2005 - 16:37:42 CST
