Re: Help a new DBA

If you are using oracle 7.2 or higher you can increase the buffer parameter. This is the size of data in bytes that exp will read in 1 go.

Also if you are stuck, try using exp help=Y this will provide you with a list of all the available options.

judysemo_at_my-dejanews.com wrote in message <71d2bj$bbd$1_at_nnrp1.dejanews.com>...
>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
>>
>>
>Hi Dave,
> I'm in the same boat that you are, but the folks who were the DBA's did
>leave me some documentation. Here's what they told me:
> 1) Login to the machine where the database is (I telneted)
> using the DBA username and password.
> 2) Then cd to the /apps/oracle/backup directory
> 3) type exp to start the export process
> you will be asked for a username and password, this should be the
> owner of the database.
> 4) accept all defaults except the filename; you should name it
> according to the date such as mmddyy.backup.dmp
> 5) Export everything (defaults again) this will take a few minutes
>
> Hope it goes as well for you as it did for me.
>
> Judy Semo
> Virginia Beach, VA
>
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Nov 02 1998 - 00:00:00 CST