RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS

Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS Guys, User apparently can only execute one stored proc. from a Crystal Reports. There are lots of different types of queries and he would like to cut-down on the number of Crystal Reports he would need. He wishes to create

RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS

Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS Paula I don't know Crystal reports so I'm not sure what you are trying to achieve, but... 1) If you're using 8i and can fix the number of bind variables (or don't need to use them at all) then native dynamic sql (NDS

RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS

Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS Yes, it looks like NDS may be able to be used - Reading Johnathon Lewis' Practical 8i with refcursor. I think this is a better approach then global temporary table. I will see if there are limitations to this using Crystal

RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS

Title: RE: HELP CRYSTAL/ORACLE FIGHTING APPROACH CUT DOWN REPORTS Need bind variables, can't fix them yes will go with global temporary tables but understand that this is going to place I/O on system that may not be necessary. -Original Message-From: Lord, David - CSG [mailto

Re: We need the help from Oracle DBAs.

You will need to perform a restore and point-in-time recovery from backup. The best option, if you have other changes that need to be preserved, is to do a tablespace point in time recovery (TSPITR). This requires restoring the appropriate backup files to create another database, rolling the

Re: We need the help from Oracle DBAs.

hey don .. did i see a hidden plug in there are what .. just kidding.. Jane, I had posted detailed tspitr steps to this list which i tried last week .. and it is a pain in the butt to configure.. that said rman tspitr is probably the way to go as don pointed out as compared to OS tspitr which is

Help interpreting Oracle CPU usage results on NT 4.0...

Hi DBA's, We are running Oracle 805 on NT in ARCHIVELOG MODE. I run the following script to list CPU usage by thread: column program format a50 column username format a12 spool C:\WINNT\Profiles\aweatherburnedb\Desktop\DBA\NT_CPU_usage.out select p.spid thread, s.username,

Urgent help on Oracle Mail

Dear Experts I am using Oracle version 7.3.2. I want to send the output of Reports thru mail. From the doc, I came to know that I should install Oracle*Mail. Where can I get this product ORACLE*MAIL ? Can I download somewhere ? any links It is not available in the original CD which is

Help with Oracle

Hi, I want to display thedata fromfew tables into Excel sheet. How do I do that? Is there any tool available? Sanjay

RE: Help with Oracle

: Multiple recipients of list ORACLE-LSubject: Help with Oracle Hi, I want to display thedata fromfew tables into Excel sheet. How do I do that? Is there any tool available? Sanjay