OraFAQ Forum: Server Utilities » How to get a db report in worddoc format??

Home » RDBMS Server » Server Utilities » How to get a db report in worddoc format??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get a db report in worddoc format?? [message #207117]

Mon, 04 December 2006 03:46

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

Hi,
we have a oracle 9i db,we have to everyday send the db report.I have tried to create a vb tool to automate the process,but it is not consistent.Is there a way to get the same,or any such tool available. Razz

Do reply,even this query doesnot seen to belong to any thread..

Report message to a moderator

Re: How to get a db report in worddoc format?? [message #207121 is a reply to message #207117]

Mon, 04 December 2006 03:57

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi,

You can create database status & database configuration report
from OEM.
Select database- > object -> create report
Select type of report.
It will be in HTML report.
Copy & paste it in Microsoft word.

Report message to a moderator

Re: How to get a db report in worddoc format?? [message #207144 is a reply to message #207117]

Mon, 04 December 2006 05:17

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

thanks seema....
The kind of report we send is through querying the tables which has been created to capture the perf data.So as for now we query the tables and ctrl c ctrl v Laughing

it.
I tried a vb tool for the same,i want to know that is it possible thru any other tool.We need a customized report.

Report message to a moderator

Re: How to get a db report in worddoc format?? [message #207212 is a reply to message #207144]

Mon, 04 December 2006 11:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can just generate HTML reports from SQL*Plus
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a90842/ch8.htm#1005596
It is not very flexible, but works.
Beaware that, SQL*Plus is not designed to be a reporting tool.
A proper reporting tool like Oracle Reports will have much flexibility.

Report message to a moderator

Re: How to get a db report in worddoc format?? [message #207338 is a reply to message #207117]

Tue, 05 December 2006 03:14

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

thanks mahesh...
yes i tried to generate the output thru this previously....
is thr a tool or freeware available which any of you are using??if yes...please let me know....

Report message to a moderator

Previous Topic:	Execute an OS command using dbms_job
Next Topic:	SYS.UTL_FILE Error in Oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 09:17:15 CDT 2024