RE: sql loader log file problem

Title: Message But wc -l OBCONT.LOAD.030909 gives 9488 . how will I find the value 8842 from the file. Thanks Manoj -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Wednesday, September 10, 2003 11:19 AMTo: [EMAIL

sql loader log file problem

Title: Message Hi All, the sql loader log file is giving the o/p as : 8842 Rows successfully loaded. 0 Rows not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Total logical records skipped: 0Total

display x square

Title: Message Hi All, I need to displaythesymbol x square i.e x raised to 2 in oracle . is it possible. Thanks Manoj This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail

RE: display x square

Hi, I do not want to display the value . Typing x superscript 2 . Thanks Manoj -Original Message- [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 4:44 PM To: [EMAIL PROTECTED] Hi Make the use of Power function. Smitha Roney COS [EMAIL PROTECTED]

RE: RE: display x square

I am not offtopic. Mq question was to display the notation x superscript 2 as written down in paper. -Original Message- Stephane Faroult Sent: Wednesday, August 27, 2003 6:19 PM To: [EMAIL PROTECTED] I am afraid you are totally off-topic. This is not a database problem, it is a

Trigger code not visible

Title: Message Hi All, I have a trigger on a table which I am not able to see inall_triggers or all_sources for the owner schema. I amnot usinga ownerschema to view the trigger in toad. I am able to view all procs,funcs and procs using the non owner acct. whenever I update a row inthis

Query Tuning urgent

BDY.RTF Description: RTF file

Oracle qry

Hi All, I've the following qry : select distinct(decode(b.sys_id,'TRDENG',a.cust_bas_no,a.cosmos_base_no)) baseno ,a.br_cod,pty_nam,bank_name from piar_fr_psd a, psd b, bank_br c where a.psd_id=b.psd_id and a.psd_serial_num = b.psd_serial_no and b.bank_id = c.bank_id and (((sys_id =

Identifying mult instances on Unix system

Hi All, I have multiple instances with multiple datadases (Not oracle parallel server) all running on my unix system. I am wondering how to identify which instances are running on my unix system, say HP-UX. Thanks Manoj -- Please see the official ORACLE-L FAQ:

ORA-02046

I'm getting the following error while trying to select from table using dblink: ORA-02046 distributed transaction already begun Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Prevent FTS

Hi All, I've 3 tables table x,y,z pk of x is (col_1,col_2),pk of y is (col_1,col_2,col_4,col_5),pk of z is (col_1,col_2) where clause is : where x.col_1 = y.col_1 and x.col_2 = y.col_2 and x.col_1 = z.col_1 and x.col_2 = z.col_2 and y.col_1 = z.col_1 and y.col_2 = z.col_2 and

RE: Prevent FTS

col_1 and col_2 are primary key columns in all 3 tables. There is no implicit data type conversion. col_1 is varchar2 and col_2 is varchar2 in all 3 tables. col width is also same in all 3 tables. -Original Message- Sent: Monday, January 06, 2003 11:52 PM To: Gurnani, Manoj If an

RE: Prevent FTS

What is the significance of parameter OPTIMIZER_INDEX_COST_ADJ ? When I tried to change the value the explain plan has changed . alter session set OPTIMIZER_INDEX_COST_ADJ = 10 table access for Z was by index rowid alter session set OPTIMIZER_INDEX_COST_ADJ = 100 table access for Z was full

dbms_lob pkg exception

Hi All, the following function gives invalid lob locator specified. b has been initialized to empty_clob() begin dbms_lob.copy(a,b,DBMS_LOB.GETLENGTH(b),1,1) exception when others then dbms_output.put_line('error');

Out of topic -Unx question

Hi All, I want to get previous date from today's date.Is there any cmd for this. Thanks Manoj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,