Recent content by djbjr

Wouldnt that be starcasm?

I imagine the following will work CREATE OR REPLACE FORCE VIEW "SYS"."NICHECOM_SITES3_VW" AS select to_number(substr(to_char("site_id"), 1, 15)) "site_id", substr("site_name", 1, 55) "site_name", substr("status", 1, 15) "status" from sites@nichecom2; EXAMPLE SQL> create table sites...

Post your Control file and a sample from the "bad" file

and yes I know I should have said an in-line view

Thanks Dave, I was answering with my Monday brain. It is a in-line view.

I believe that is simply called a sub-query.

Try the following SELECT c.* FROM csq_mc c, (SELECT mc_location, MAX(mc_date) max_date FROM csq_mc GROUP BY mc_location) m WHERE c.mc_location = m.mc_location AND c.mc_date = m.max_date; RESULTS: SQL> create table csq_mc 2 (mc_date date, 3 mc_location varchar2(10)...

Thanks bcaster but I dont think that will help in our situation. What happened was he sat at his desk and a window popped up that certain files were ready to be burned, they were all confidential data files. I was trying to help him out to figure out if the person that was let go actually...

I am the resident computer geek amoung my friends but I was stumped today and was wondering if any of you guys might know. My friend wants to know when the last CD was burned on his computer. He had to fire someone recently and he is afraid that person may have took his data and made a copy...

Post the script for your trigger and perhaps we can help

Paul- Thanks for the help, I have figured it out. The problem was that the file was not being created because the sql*loader command that I was running earlier in the script was not executing. Thanks a ton and I will post again if I need more help dj

Paul- Thanks for the hint but that isnt going to work. The .data file is the flat file that I am going to use to load into Oracle. I changed it to look like .log instead of .data.log and it is still giving me the same error.

Thanks for your replys, the problem was that I had an incomplete parameter file so the full path of the file was not being searched for. Now I have a new problem. I am getting an error that it cant open the log file. hr_load 08/24/106 08:58:47 ps_disability STARTED hr_load 08/24/106 08:58:47...

I hear what your two are saying but my thoughts that the file name was wraping to the next line. If you look at my error log, it continues with the filename....or maybe you are right and this is an additional message. Thanks for your help In the meantime I will try the -e approach.

Probably a poor subject line but I really dont know what I am doing. I am an Oracle developer that has inherited a 9 year old Perl script that moves files and kicks off Sql*Loader scripts. We are moving off of Unix and on to Linux and this script is acting crazy now. I wonder if any of you guys...