Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sysusers deleted

Re: sysusers deleted

From: Brian Dick <bdick_at_cox.net>
Date: Fri, 14 Jan 2005 14:17:55 -0500
Message-ID: <MPG.1c51e4ee469f922d98968f@news-srv1.fmr.com>


In article <1105120566.3bac3e1753bff50737f2d62b0c8c8cbc_at_teranews>, wizard_ozREMOVE_at_gmx.net says...
> 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.
>

People who support both Sql Server and Oracle often create views that make it easy to run the same queries against both. In this case my bet is that sysusers was a view that made the Oracle dictionary look similar to the Sql Server sysusers table. Received on Fri Jan 14 2005 - 13:17:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US