Home » RDBMS Server » Server Utilities » How to get a db report in worddoc format??
How to get a db report in worddoc format?? [message #207117] Mon, 04 December 2006 03:46 Go to next message
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..
Re: How to get a db report in worddoc format?? [message #207121 is a reply to message #207117] Mon, 04 December 2006 03:57 Go to previous messageGo to next message
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.
Re: How to get a db report in worddoc format?? [message #207144 is a reply to message #207117] Mon, 04 December 2006 05:17 Go to previous messageGo to next message
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.
Re: How to get a db report in worddoc format?? [message #207212 is a reply to message #207144] Mon, 04 December 2006 11:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: How to get a db report in worddoc format?? [message #207338 is a reply to message #207117] Tue, 05 December 2006 03:14 Go to previous message
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....
Previous Topic: Execute an OS command using dbms_job
Next Topic: SYS.UTL_FILE Error in Oracle 10g
Goto Forum:
  


Current Time: Tue Dec 06 02:25:39 CST 2016

Total time taken to generate the page: 0.11841 seconds