Recent content by uparna

any reason you are sticking to dedicated connection mode? Why not have connection pools? Regards, S. Jayaram Uparna . :-)

Hi , I have new requirements with me here which shows around 300 tables in a 10G database that have to go into a warehouse (another 10G DB to be designed). All ETL will be done by informatica since the databases are geographically separated and each one cannot access the other. Now i want to...

had put it there before this thread itself - no responses yet -- and the clock is ticking.... sigh :-( thanks anyway ! Regards, S. Jayaram Uparna . :-)

Use the RANK or the Row_Number function for this - looks like you dont want count , but want the rank of appearance. Regards, S. Jayaram Uparna . :-)

Bump [morning] [sadeyes][nosmiley] [sadeyes] Regards, S. Jayaram Uparna . :-)

[sadeyes][morning][nosmiley] Regards, S. Jayaram Uparna . :-)

bump :-) Regards, S. Jayaram Uparna . :-)

Folks, i am back with a problem. :) We have an OWB mapping that is configured to do ETL operations on a large amount of data. When we tested this in our development environment ( which had around 50000 rows), it ran just fine - in production though, since we have around 500000-600000 rows(10...

Folks, i am back with a problem. :) We have an OWB mapping that is configured to do ETL operations on a large amount of data. When we tested this in our development environment ( which had around 50000 rows), it ran just fine - in production though, since we have around 500000-600000 rows(10...

Dave , Yes , i understand that -- and i am concentrating on the last_ddl_time only -- not the created time. Strangely, the prod db was analyzed over the weekend , and i now see the proper compile times there....so the analyze seems to have woken up the all_objects view from its slumber. I cant...

Dave , yes, this is what i suspected----and you have answered my Q1. i am very interested in the answer to question 2 -- why did the sp compile time not change in the all_objects view , though i knew explicitly that it had changed? Your test above seems to prove that "analyze" is not the...

Hi, Which sys table/view contains the information on when an SP was compiled? (Question-1) Last_DDL_Time in All_Objects seems to be the answer, but even on compiling my SP , the time didnt appear to change in this table -- Is this table updated only on every analyze, right? (Question 2) If...

Here is the situation i am in:- I have to generate a random 6 digit number. Sounds simple. SELECT ROUND(DBMS_RANDOM.VALUE(100000,999999)) NUM FROM DUAL; Ah! here are the couple of catches:- 1) This number should not be a previously generated number ( stored in a difft table, called table X)...

oops -- my bad -- i am revisiting the many-rows-to-a-single column approach -- ie reasons 1 2 3 should come as reasons 1,2,3 sorry for not clarifying -- my bad. Regards, S. Jayaram Uparna . :-)

hi , i am kind of revisiting this and am trying if its possible using ONLY sql (without a func etc) in 9i --- does anyone have any idea? Regards, S. Jayaram Uparna . :-)