Oracle Question

Does anyone know if there is a master reset for our Oracle spaces to completely claer out EVERYTHING that we added in?  The drop tables command doesn't seem to be cutting it and our database hates us.

Comments

[Tom Campion]

Hey Krysta,

I see that your DB hates you, too. My group members and I endured a long and bitter struggle with ours before figuring out how to get back to a clean slate.

I'm assuming that when you go to drop table you come across errors that say you can't delete your tables because foreign keys are referenced all around. It really sucks. We figured out eventually that it was like a puzzle. To drop all the tables, you have to do it in the right sequence.

Now that I've written all this out, I realize it's probably of little help to you because you know all this. You are a huge contributor to the blogosphere and appear to certainly understand all of this better than I do. Maybe this response will be helpful to you, but right now I'm beginning to doubt it. I hope it helps, though.

Best,

Tom

[srikant]

for oracle exam(sql)what are the websites available