Re: backup question

In article <8e9588$fs6$1_at_newton3.pacific.net.sg>,   "lkw" <lkw_at_axiomatique.com> wrote:
> Hi all,
>
> I know we can use export and import utility to backup oracle database.
> but we have to do that either using Enterprise Manager or run the
 utility at
> Command Prompt.
> So, is there other means to run this utility?
>
> izzit possible to run it within a stored procedure? which means ask a
 stored
> procedure to
> back up a dump file whenever necessary.
>
> Your great help would be greatly appreciated!! Thanks!
>
> Puzzled,
> lkw.
>

Most Oracle Unix based DBA's probably perform their regular exports tasks by setting up a cron job to run a shell script that is set up to run the exp utility in batch mode. That is how we run ours. We do basically the same thing under VMS also except the System Administrator has the system run a DCL script that we set up.

Doesn't the OEM tool has a scheduling feature? I do not use OEM so I have never played with trying to use it.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.