Friday, March 9, 2012

problem deleting database using enterprise manager

I am trying to delete a database using Enterprise Manager. It seems like
everything works fine, the db is gone from the Databases tree, but when I
try to create a new database with the same name as the one I just deleted, I
get an error stating that the database exists. Also if I try to delete a
login associated to the deleted database, I get the error that it cannot be
deleted because it owns objects in the deleted db. I really don't understand
what's going on here. Could anybody help me out?Richard
Have you REFRESH the EM after droping db?
"Richard Gjerde" <richard_gjerde@.yahoo.no> wrote in message
news:fdKNd.7739$IW4.168987@.news2.e.nsc.no...
> I am trying to delete a database using Enterprise Manager. It seems like
> everything works fine, the db is gone from the Databases tree, but when I
> try to create a new database with the same name as the one I just deleted,
I
> get an error stating that the database exists. Also if I try to delete a
> login associated to the deleted database, I get the error that it cannot
be
> deleted because it owns objects in the deleted db. I really don't
understand
> what's going on here. Could anybody help me out?
>|||Well, I just did:-) And the db came up as "suspect". When I dropped it again
it was OK.
So the problem sort of disappeared, but I am still unsure about why it
ocurred in the first place.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23OH5euRDFHA.512@.TK2MSFTNGP15.phx.gbl...
> Richard
> Have you REFRESH the EM after droping db?
>
> "Richard Gjerde" <richard_gjerde@.yahoo.no> wrote in message
> news:fdKNd.7739$IW4.168987@.news2.e.nsc.no...
> > I am trying to delete a database using Enterprise Manager. It seems like
> > everything works fine, the db is gone from the Databases tree, but when
I
> > try to create a new database with the same name as the one I just
deleted,
> I
> > get an error stating that the database exists. Also if I try to delete a
> > login associated to the deleted database, I get the error that it cannot
> be
> > deleted because it owns objects in the deleted db. I really don't
> understand
> > what's going on here. Could anybody help me out?
> >
> >
>|||Richard
I prefer using DROP Database by QA not by EM.
"Richard Gjerde" <richard_gjerde@.yahoo.no> wrote in message
news:sEKNd.7744$IW4.168621@.news2.e.nsc.no...
> Well, I just did:-) And the db came up as "suspect". When I dropped it
again
> it was OK.
> So the problem sort of disappeared, but I am still unsure about why it
> ocurred in the first place.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23OH5euRDFHA.512@.TK2MSFTNGP15.phx.gbl...
> > Richard
> > Have you REFRESH the EM after droping db?
> >
> >
> > "Richard Gjerde" <richard_gjerde@.yahoo.no> wrote in message
> > news:fdKNd.7739$IW4.168987@.news2.e.nsc.no...
> > > I am trying to delete a database using Enterprise Manager. It seems
like
> > > everything works fine, the db is gone from the Databases tree, but
when
> I
> > > try to create a new database with the same name as the one I just
> deleted,
> > I
> > > get an error stating that the database exists. Also if I try to delete
a
> > > login associated to the deleted database, I get the error that it
cannot
> > be
> > > deleted because it owns objects in the deleted db. I really don't
> > understand
> > > what's going on here. Could anybody help me out?
> > >
> > >
> >
> >
>

No comments:

Post a Comment