Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OMS Question
On Fri, 8 Apr 2005 01:47:26 +0200, Bernd Renzing wrote
(in article <d34gqf$fir$04$1_at_news.t-online.com>):
> Hello Ronald,
>
> Ronald Rood wrote:
>
>>> I want to use OMS for executing some SQL-Scripts (as Job) on each database. >>> BUT I want to get some of the Results of these Scripts into a central >>> Table/Database
>> This can be done with scheduled reports and a piece of tcl code that >> converts >> the html table[s] to csv and sqlloader. Just start with a scheduled report >> and edit the job that gets created for it.
Bernd,
I just uploaded grab.tcl to my scripts page on http://ronr.nl/unix-dba
It should be usable as a start and you will have to google around for some
dependencies.
With kind regards / met vriendelijke groeten, Ronald
http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle
Received on Fri Apr 08 2005 - 10:12:51 CDT