Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to refresh the complete database using the export dump?.

Re: How to refresh the complete database using the export dump?.

From: Anant <>
Date: Tue, 17 Jul 2007 12:39:56 +0530
Message-ID: <>

Hi All,

I could see many reactions with respect to my topic or a question. Actually I was not clear in my doubt coz I did a blunder when i was doing the schema import. I dropped the users with cascade and schemas in the wrong database so i was not getting the solution what to do at this point as i am new to DBA.I totally accept Robert's suggestions. I kindly apologise for this mistake.

*Mark Brinsmead* : I was in a hurry to find the import command to fully recover the database. Anyways thanks for your kind reply and suggestion.Iwill try to correct my mistake before putting a question.

*Bryan Wells* : Thanks for your kind support too for being considering me as a learner and fresher. But I would request you to not to leave this community for these reasons as said. I would say that these comments will obviously come out as all the fingers in the hand are not of the same length like all the people will not have the same frequency in answering. Hope I would get a reply from you for this mail.

Will assume that no one is hurt with these above things.

Thanks and Regards,

On 7/15/07, Robert Freeman <> wrote:
> It's Sunday today, so perhaps the lesson today should
> be one of humility. Are the words Humility and DBA
> truly antonyms? I don't think so.....
> Me thinks, perhaps. To refuse to post here is an act
> that not only hurts yourself, but hurts the many other
> people who read but don't post here. I also think it's
> a rash over-reaction and borders on selfish. If this
> were a community that was flame ridden, I'd
> understand, but it's not. So, perhaps some humility is
> in order.
> If you look at your question, which was a pretty basic
> question, it does somewhat imply that you had not read
> the freely available documentation. Many of us here
> (including myself) feel like that the first step to a
> problem like this should be to at least crack the
> documentation and try to figure out the problem for
> yourself. Failing that, then you post here.
> That is a sign of respect for the community, and a
> sign that you have made some effort to solve your
> problem. Remember, we all work for a living here. Many
> here are consultants who typically BILL for our time
> to answer questions. Here you get it for free. That is
> something that I think needs to be respected too.
> Perhaps there is a more gentle way to point out this
> fact, but to be honest when you are heads down doing
> lots of real work AND replay to online posts,
> sometimes tact will end up being a victim. It's
> nothing personal, it's just the way things are.
> I think if you had posted something that said, "I have
> a database at work that is down and I need to get an
> import loaded... I'm a new DBA and I don't know how to
> do this and I need help fast, please!" then your
> answers would have been fast, furious and forthcoming
> because you were clearly in trouble. There are many
> here that have a heart and would empathize with your
> plight. In that case, I doubt the words "RTFM" would
> have ever be spoken. They might, after the fix was
> done, but I don't think during any crisis.
> This is a close community, with a number of people
> that *care*...and that I call friends and have for a
> long time. They also realize that it is better to
> teach one to fish than to fish for them if at all
> possible. This is also a community, as Dan pointed
> out, that is based on written communication which is
> notoriously bad when it comes to interpretation of
> emotion and content.
> Also, as with any community, there may be those who
> are less patient than others (I'm not saying this was
> the case here at all) as we are all human beings here.
> We all have good days, bad days and days in between.
> To judge a community based on one or two experiences
> is, again, a great disservice.
> So, I think my point is this: many of us here love
> what we do. Many of us here love to help. It's a grave
> mistake to stop being a part of this community because
> of a little squabble.
> RF
> Robert G. Freeman
> Author:
> Now Available for Pre-Sales on!!!!
> **************************************************
> Oracle Database 11g New Features (Oracle Press)
> **************************************************
> Portable DBA: Oracle (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Oracle9i RMAN Backup and Recovery (Oracle Press)
> Oracle9i New Features (Oracle Press)
> --

Received on Tue Jul 17 2007 - 02:09:56 CDT

Original text of this message