Re: Ideas for exporting

From: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 09 Nov 2001 01:07:31 GMT
Message-ID: <Xns9153AE354F4E4SunnySD@24.0.3.73>

"Chuck" <chuck_hamilton_at_yahoo.com> wrote in news:9se9pc$12t01d$1_at_ID- 85580.news.dfncis.de:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> My boss has asked me to write a shell script that will go out nightly
> to every server and do a no rows export of each database. This is for
> the purpose of backing up DDL, grants, users, passwords, etc. I'm
> looking for ideas that you think would be the best way to do this.

It would be REAL helpful if you had mentioned which flavor of OS!

One possible solution would be to write a PL/SQL package that use UTL_FILE to create the driver script for each instance. You could use DBMS_JOB to schedule the script creation & then use cron or AT to actually run the script which generates the desired output.

HTH & YMMV! Received on Thu Nov 08 2001 - 19:07:31 CST