Re: Help a new DBA

On 31 Oct 98 21:58:16 GMT, tpall_at_bga.com (Thomas Pall) wrote:

>Each table exported will be read consistent. However if there is update
>activity going on, tables will not be consistent with each other.
>
>Quinton McCombs (quintonm_at_bellsouth.net) wrote:
>: exp user/password file=<dumpfilename> full=y consistent=y direct=y
>: log=<logname>
 

>: This will create a read consistent export of the database for you.
 

>: judysemo_at_my-dejanews.com wrote:
>: >
>: > 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
>
>--

This is incorrect, using consistent=Y causes a dump to be taken which is consistent across all tables as of the time the export started.

Regards

Clive.

--
Clive Bostock