Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sysusers deleted
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