Re: Help a new DBA

Hi there,

In Windows NT (you didn't mention platform) you simply run your EXPORT utility from the DOS prompt. Check the name of the import utility executable in \orant\bin directory.

eg) DOS> exp73 username/password_at_hostname

It will save the file as "EXPDAT.DMP" (or you may rename with .dmp extension) in the current directory. It will prompt you for various options, which will be somewhat self-explanatory. This will create a nice little dump file just waiting for import to its new home. When you're ready to import use the IMPORT utility, ie) imp73.

Good luck!

In article <36374C1F.AD47B767_at_iname.com>,   Dennis Chebotarev <tdennis_at_iname.com> wrote:
> Use Oracle Export Utility (EXP73) and export whatever they want.
>
> Dave Rhodes wrote:
>
> > Hi
> > Hope someone can help me. I was on a Oracle training course last week, and
> > now I've been made into DBA (prior to the course, I'd never seen or used
> > Oracle) so I'm a bit bewildered by everything at the moment.
> >
> > I've been asked to create a 'dump' of our database. Can anyone tell me
> > what this means, and more importantly what I need to do.
> >
> > Do I have to use EXP73 and export something, or is this something I do with
> > SVRMGR? (That's all I've managed to find out about so far)
> >
> > I'm using Oracle 7.x (I don't know what version)
> >
> > Thanks in advance
> > Dave
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 11 1998 - 00:00:00 CST