Career Advice

the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani

RE: Career Advice

exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM

RE: Career Advice

be with you. On 12/17/2003 12:44:28 PM, Saira Somani-Mendelin wrote: As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP

RE: Career Advice

question you asked Allan -Original Message- Saira Somani-Mendelin Sent: Wednesday, December 17, 2003 11:44 AM To: Multiple recipients of list ORACLE-L As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice

RE: Career Advice

the app you are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL

RE: Career Advice

an IT career. What we do is not rocket science but you can't do rocket science without us. Good luck in your future. Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Career Advice

: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: Career Advice

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Career Advice

your scripts your write on a cd you can take it with you for a long time. We all have our pile o'scripts we take with from place to place. Have fun! Brad O. -Original Message- From: Saira Somani-Mendelin [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17

RE: Career Advice

are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL

bad SQL day...help please

50340 20020 RPCK6 50340 20020 SHIP6 50340 701079 PICK100 50340 701079 SHIP100 50340 701206 RPCK30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET

RE: SQL*Plus errors... how to hide?

I like this solution. It works way better than the dbms_lock.sleep() suggestion ;) Thank you. Saira -Original Message- Sent: November 6, 2003 3:54 PM To: [EMAIL PROTECTED] Cc: Saira Somani-Mendelin Catch the error in an exception clause and ignore it. SQL set

RE: SQL*Plus errors... how to hide?

: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: SQL*Plus errors... how to hide?

song [EMAIL PROTECTED] Before God we are all equally wise - and equally foolish. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL

SQL*Plus errors... how to hide?

RELEASE_PO_B_H('yrugis'); END; * ERROR at line 1: ORA-01722: invalid number ORA-06512: at TRAIN65D.RELEASE_PO_B_H, line 16 ORA-06512: at line 1 Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City

PL/SQL - can't accept user input - then how?

: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

Re: PL/SQL - can't accept user input - then how?

Thank you all. Your suggestions have clarified A LOT of grey areas for me. I'm not an expert shell programmer but I can certainly get by on these suggestions! Thanks again. Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED

RE: Third party application - how to begin performance tuning efforts?

(this part is for the original poster, Saira Somani), you create a small copy of your production database, by using exp rows=no, if necessary and then repeat the query in that small database, where you can tweak the parameters, the structure and the quantity of data. That means that you can force

RE: Third party application - perf tuning...etc.

? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Third party application - how to begin performance tuning efforts?

. Anyone else attending this conference? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Reducing the number of databases

Title: Message Unfortunately, thats what we have! And yes, my resume is on-line Our database configuration and installation was outsourced and so was the installation of our ERP. So guess what happened? No consultation with the support analyst and now they want to split the

RE: ORA-16014

://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

ORA-16014

: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: How to keep root out?

Title: Message Cant root user change any file on the system regardless of the file owner? If the SA doesnt know about this line of code or about oraenv, then it will work for a while. I think Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On

Re: GREAT SCOTT!! 1.21 GIGAWATTS!!

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: [stupid] vi question

list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

SQL*Loader - append to a table while checking column against another table

records. Seems like a roundabout way to do things - it definitely works for me but I just wonder if there is an easier way. Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services

OT: [stupid] vi question

Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: running 9i database and 11i apps on Linux - Good idea?

Yes I think so. I went the other way knew Linux well and moved over to AIX. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fedock, John (KAM.RHQ) Sent: July 30, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: running 9i

RE: 8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1

ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

8.1.7 instance on upgraded AIX machine - ORA-1652 all the time

see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 8.1.7 instance on upgraded AIX machine - ORA-1652 all the time

== -Original Message- Saira Somani Sent: Sunday, July 27, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application

Re: 8.1.7 instance on upgraded AIX machine - ORA-1652 all the time

, allocations and alike. You are probably using 64 bit JFS on 5L, straight up from 32-bit 4.3.3? On 2003.07.27 00:39, Saira Somani wrote: Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our

Oracle 9i Lite and cellular technology

but who would that be? What about changes to the application? If anyone else has explored this possibility or has implemented it, sharing your experiences would be greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin

RE: Oracle 9i Lite and cellular technology

: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

ORA-01722 while using sqlldr

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL*Loader problem - constraint violation

in the index (of course not because the index is to be unique). But I checked lc_rid for duplicates and didn't find any. So what am I missing here? Thanks, Saira -Original Message- Saira Somani-Mendelin Sent: July 7, 2003 3:59 PM To: Multiple recipients of list ORACLE-L I'm new to sqlldr and here

RE: SQL*Loader problem - constraint violation

in the index (of course not because the index is to be unique). But I checked lc_rid for duplicates and didn't find any. So what am I missing here? Thanks, Saira -Original Message- Saira Somani-Mendelin Sent: July 7, 2003 3:59 PM To: Multiple recipients of list ORACLE-L I'm new to sqlldr

SQL*Loader problem - constraint violation

constraint (TEST65W.LCI_LOC) violated LCI_LOC looks like this: CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) If anyone can help, it would be very appreciated. Thank you, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED

OT: uuencode and mail

receive what is in testmsg as the body of the e-mail and not the csv attachment. If anyone can contribute to a solution, I'd be grateful. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services

RE: uuencode and mail

] On Behalf Of Saira Somani Sent: Wednesday, June 11, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Subject: OT: uuencode and mail Hi all, Platform: AIX 4.3.3 I realize this off topic but it is somewhat related. Each morning a cron job creates an SQL*Plus output in csv

RE: Good technical documents/references on tuning restores

Title: RE: Good technical documents/references on tuning restores Weve had this occur before. Check connections at the physical layer they might be loose. We changed the Ethernet cable and it seemed to work optimally after that. The cable should ideally be better (more insulated) than the

SQL statement problem - outer join where?

' AND F.DIV_CODE='01' AND F.CANCELLED='N' AND B.CUST_NUM='2' AND F.ORDER_DATE=SYSDATE-1 ORDER BY F.ORDER_DATE, C.SORT_NAME; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: OT: uuencode adding characters

Thanks. I guess this would be a good time to learn Perl :) -Original Message- Berry Sent: March 27, 2003 4:39 PM To: Multiple recipients of list ORACLE-L From: Saira Somani [EMAIL PROTECTED] AIX 4.3.3 ORACLE 8.1.7.0.0 I have a spooled report from an SQL script which I am e-mailing

RE: OT: uuencode adding characters

To: Multiple recipients of list ORACLE-L From: Saira Somani [EMAIL PROTECTED] AIX 4.3.3 ORACLE 8.1.7.0.0 I have a spooled report from an SQL script which I am e-mailing, also from a script using the uuencode utility. The spooled report looks fine but once it is e-mailed, it looks funny with carriage

OT: uuencode adding characters

://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

DW reading for design and implementation

practices? Is anyone able to recommend websites, articles, **books**, or share similar experiences to point me in the right direction? Thanks in advance for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network

RE: Number of joins in the query

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: SQL struggle - UPDATE too?

4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc

RE: SQL struggle - UPDATE too?

the UPDATE statement. Also, added WHERE whse_code 'HL1' so the source last_cost is not updated to its current value (reduces redo log entries and rollback segment usage). Have Fun :) Saira Somani wrote: I am very confused (and fairly new to SQL which would be my excuse to post such amateurish

RE: SQL struggle - UPDATE too?

, added WHERE whse_code 'HL1' so the source last_cost is not updated to its current value (reduces redo log entries and rollback segment usage). Have Fun :) Saira Somani wrote: I am very confused (and fairly new to SQL which would be my excuse to post such amateurish questions on this list

RE: SQL struggle - UPDATE too?

last_cost = hl1_cost / Note: whse_code and item_num could be removed from the UPDATE statement. Also, added WHERE whse_code 'HL1' so the source last_cost is not updated to its current value (reduces redo log entries and rollback segment usage). Have Fun :) Saira Somani wrote: I am very confused

SQL struggle

Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED

RE: SQL struggle

: February 25, 2003 1:57 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: SQL struggle (see answer below) -Original Message- From: Saira Somani [mailto:[EMAIL PROTECTED]] Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w

RE: SQL struggle - UPDATE too?

And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

RE: UPDATE...REPLACE...#39;...apostrophe...

Message- From: Saira Somani [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL struggle Thank you for your assistance - it works - and I have one more question: How can I also get the SELECT to show me the original item

RE: Oracle 9i Lite - any help please?

Mogens, We did exactly as indicated in the e-mail from Martin and were encountering the same problems as before. Any helpful hints from your colleagues would be much appreciated. Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

RE: Oracle 9i Lite - any help please?

Windows patch (the latest on Windows).   -- martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Oracle 9i Lite - any help please?

until it is successful (which sometimes it is and sometimes isn't). However, even when the PROCESSING bar has not completed until the end, the data from the PDA is sent but this is unreliable as all the MSYNC processes are not complete. This is inefficient. Any suggestions? Saira Somani

RE: Oracle 9i Lite - any help please?

both ended up working with IT. If Jacob responds (he's a rather busy guy) I'll forward the responses to the list. Can I ask you what you think of Lite in general? I don't see many sites using it, but it looks like a cool thing for the right purpose... Best regards, Mogens Saira Somani wrote

over-normalized?

Is there such thing as an over-normalized database design? What defines over-normalization? And what are its consequences? (Other than the obvious degraded database performance and lots of tuning) I hear rumblings that our ERP system is over-normalized. Just curious, Thanks! Saira Somani

ORA-2289 - anyone?

the sequence name is correct, and that you have // the right to perform the desired operation on this sequence. CUNAME:cu4 STATUS:-255 NATERR:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital

RE: ORA-2289 - anyone?

(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

ORA-2289

have // the right to perform the desired operation on this sequence. CUNAME:cu4 STATUS:-255 NATERR:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please

RE: Orawomen

-- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

8i OCP DBA Exams

these exams? Thanks. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Happy Holidays!!

Rachel, I'm in that category too. Newest Oracle DBA/Sys Admin on board at a 3rd Party Logistics company - Hospital Logistics Inc. And I admit! I'm a lurker :-) Saira Somani Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET

RE: 9i Lite

it now and would like to brainstorm once in a while on this topic. I struggle with its administration sometimes. If you can point me in a direction (other than the Oracle forums on their website), I would appreciate it. Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please

RE: 9i Lite

devices like pda's etc. Regards, John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

9i Lite

than the Oracle forums on their website), I would appreciate it. Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

replicate schemas

Hello Listers, This might be a very newbie-type question but I would like to know how I can replicate a schema in the same instance under a different schema name, of course - same data, etc. Thanks for your help. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see

ORA-01089

the archives but didn't find a satisfactory explanation. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Oracle to Excel

Title: Oracle to Excel I usually spool my queries to a .txt (ascii) file and import into Excel. Easiest way for me. Im sure there are other more sophisticated solutions out there. Regards, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf

Oracle 8.1.7 R 3 for W2K Sever on P4 Xeon Processor - problems?

Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

update statistics

What is the equivalent in Oracle of the Informix UPDATE STATISTICS? Thanks much. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

trace an SQL session

if the query is a resource hog. Is it possible to trace that as well? Running Oracle 8.1.7 on AIX 4.3.3! Thanks in advance. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED