Ideas for exporting

-----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.

I have a table that stores the Net8 service name of every instance and originally I thought I'd just query that in a script and do an export over the network for each one. The problem with that is that there are numerous versions of Oracle installed and I don't have a server that has all versions of the export utility. If I write the script to just do local databases, I can get to the right version of exp okay, but then I've got about a dozen copies of the script to maintain, some for unix and some for windows.

How would you go attack this problem? Is there a better way?

-----BEGIN PGP SIGNATURE-----

Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO+qqc2m5A4kkb4ZsEQIjGQCdHlbxPPDSWMLPqWe9qQkSMt8sqD4An1O3 2BLGFWRbWQZqUpnN0BtqcIgI
=/+G/
-----END PGP SIGNATURE-----
Received on Thu Nov 08 2001 - 09:53:31 CST