Recent content by bheemsen

Hi, We recently upgraded to Oracle 10.2.0.2 from Oracle 9.2. Our OS is: Unix AIX After the upgrade we are facing a strange problem with our sql loader. We load several flat files everyday one after the other into our flat tables using sql loader. After the upgrade, the sql loader hangs...

The two variables I was talking about are: AND c.db_dca = vCableNum (from 1st query) AND c.db_dpair = nPairNum (from 1st query) I was able to merge the two queries as follows. All the tables are analyzed. SELECT --+FIRST_ROWS e.cable_num, f.pair_num, c.vdsl_summ FROM tab4 a...

Hi, I have the following queries in a procedure and the performance is very bad. I need help in combining these two queries. 1) this is the cursor SELECT --+FIRST_ROWS DISTINCT a.cable_num, b.pair_num FROM tab1 a, tab2 b, tab3 c WHERE a.col1 = b.col1 AND b.col1 = c.col1 AND a.col2 = c.col2...

Hi, I am new to BO. I am trying to create a universe using BO designer. I am able to see the oracle table columns when I add them to universe. However when I add a remote table (synonym), I am not able to see its columns. I am able to create the class for that table, but again while trying to...

I think errors=999 is causing the problem. My question is this parameter error=999 for eack file or for entire SQL loader session. Looks like once this error limit is reached SQL loader is not loading all the other files after that. Is this true for all others too ? Thanx.. -Bheem

Here is a sample of data file. 616399|6163990404|1|COPPER|26|1.657| 616399|6169940058|1|COPPER|22|0.016| 616399|6169940058|2|COPPER|22|2.868| 616399|6169940616|1|COPPER|24|3.320| 616399|6169940616|2|COPPER|26|1.173| 616399|6167862498|1|COPPER|24|1.408| 616399|6167862498|3|COPPER|26|0.230|...

Strange SQL Loader problem. We are encountering a strange SQL Loader problem. Here are the details. We are using the following oracle version. Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production OS - Unix IBM AIX The sqlldr is invoked from within a Unix shell script using...

We have lots of Shell scripts where the password is hardcoded to connect to the database(Oracle): Ex: sqlplus username/password The password should not be in clear text & should be encrypted before connecting to the backend. Oracle will not take encrypted passwords in my opinion to connect to...

I am trying to use a procedure call in an update query, But it is not working. The main procedure is not getting compiled. I am on oracle 9i. The statement is UPDATE --+INDEX(BPT_TO_DLM BPT_TO_DLM_INDEX) bpt_to_dlm SET rmt_trml_ind = NULL, rmt_trml_avail_ind = NULL, rmt_trml_clli_cd = NULL...

Thanks. That is fantastic. Your explantion is good and easy to understand. -Bheem

I am sorry, that was a typo. da_completed_id should be da_completed_ind.

Hi, The following query works fine in SQL Server and I would like to achieve the same in Oracle 9i. It does not work in Oracle. Can any one help who knows the equivalent of this in Oracle ? UPDATE WEB_FSP_DATA a, WEB_DA_CERTIFICATION b SET a.address_qualified_date = SYSDATE, a.da_completed_id...

Hi Gurus, I found that whenever my procedure is called, it is precompiled. Is there any way I can tell SQL Server not to precompile a particular stored procedure ? I appreciate your responses. thanx.. -Bheemsen

Hi, I could get answers to some of my questions. 1. Each thread will have its own copy of temp table. 2. Not sure whether tempdb is locked. 3. No drop required. Anyway I am going to add this in the procedure. 4. I still could not find any alternate solution for this. I did a volume testing...

Hi, I am using temp table in my stored procedure. The temp table is first created and rows are inserted. Then I am selecting data from same temp table. Everything is inside the stored procedure. This stored procedure is called from a Java (EJB) program with at least 100 threads at the same...