Re: Help a new DBA

Hi Dave,

In 'DBA ' language, dumping a database is just a way to say 'saving the database ' (except you can choose if you save data or objects structure...) You have to use exp73 (for Oracle 7.3 of course!) at the command line. exp73 help=y will give you all the parameters you may choose one of the following workflow : Type exp73 and follow the instructions
Type exp73 with command line parameters
 I suggest you choose the second way ...you can have a log file ... if you want to export all you database :

    exp73 username/password file=export_file.dmp full=y grants=y log=export.log

Note: you can choose other extension than .dmp !!! And for more information takea look at the oracle utilities book

Dave Rhodes wrote in message <01be026e$ea1a41c0$1300a8c0_at_peterb>...
>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
Received on Wed Oct 28 1998 - 00:00:00 CST