Generate report in OEM
Team,
I'm having a problem in generating a Tablespace usage report through OEM, not sure if am missing something while doing this.
Oracle Version : 11.2.0.2
OS : Linux
I used the option of create like from the original tablespace usage report provided by oracle, I gave the target name and provided the mail address and scheduled it. I'm getting the mail with the report format I specified but the data is always empty. I did this using my ID created in OEM. My questions are :
1) Should my ID have any special privileges granted to do this
2) I thought when I use the create like option, new report will take the script required for getting the tablespace usage data from this. Is it wrong? Should I provide any script as input to do this , like we do for a job
3) Target(Server) have multiple databases on it, I want the report to be generated for only one database, I dont see an option to specify one database from multiple on that host. How should I achieve this?
Thanks in advance