Re: Oracle Diagnostic and Tuning Packs

Hello Peter We did a comparison between quest tools and OEM. The bottom line was that all these tools gives you about the same functionality and there is no BIG difference between them. Our manager got a better deal from Oracle so we bought these packs. We hope to start implementing them this

Re: Oracle Diagnostic and Tuning Packs

I will have to respectfully disagree with that, at least in part. There is a big difference between change management in OEM tools and Quest tools, Quest's tools being much better. The OEM tools are push button, just like MicroSlush garbage. Meaing: The OEM tools do no give you near the

RE IMPORT Urgent

In digest mode so sorry if I'm late :) These tables on the production database are protected so I can export them only as sys user.I am attaching the log from the import.What is the problem. Am i missing anything I believe the tables will still be owned by the original user. We probably

RE: Oracle Diagnostic and Tuning Packs

And I normally don't disagree with you Jared but in this case I must. I evaluated both quite extensively just a month or so ago. They both give you the same type of control really, just in a slightly different format. OEM's was actually easier to use with no prior instruction. Both are push

ways to allow developers to see all packge bodies without EXECUTE ANY PROCEDURE?

Good day listers, We have some developers that would like to see all the package bodies in our data warehouse. This is a reasonable request. The developers use Toad, which used the ALL_SOURCE view. I pulled the code for all_source and discovered that the execute_any priv exclusion is hardcoded

SQL Help Urgent!!!!!!!!!

Hi gurus I have two tables like this SQL select * from bb; ID AMOUNT DT-- -- -- 1 1000 10-MAY-02 SQL select * from cc; ID AMOUNT-- --- 1 200 1 300 1 500 My query like this = SQL select

SQL Help Urgent!!!!!!!

Hi gurus I have two tables like this SQL select * from bb; ID AMOUNT DT-- -- -- 1 1000 10-MAY-02 SQL select * from cc; ID AMOUNT-- --- 1 200 1 300 1 500 My query like this = SQL select

Create user_exit under unix

Dear Gurus, I use : - Oracle Server 8.1.6.0 - Oracle Pro*FORTRAN 1.8.52.0.0 - Oracle Developer 6i release 2 Under SUN Solaris 2.8. Could you please tell how to create USER EXIT on Oracle Developer 6i using those tools above? I'll very apreciate for every reply. regards, Ahmadsyah A.N. --

RE: SQL Help Urgent!!!!!!!!!

Select a.id,a.amount,ccinlineview.bamt from bb a,(Select id,sum(b.amount) bamt from cc b group by id) ccinlineview where a.id = ccinlineview.id ID AMOUNT BAMT -- -- -- 1 1000 1000 1 row selected. -Original Message-From: sultan [mailto:[EMAIL

Re: SQL Help Urgent!!!!!!!!!

sultan wrote: Hi gurus I have two tables like this SQL select * from bb; ID AMOUNT DT -- -- -- 1 1000 10-MAY-02 SQL select * from cc; ID AMOUNT --