Search results for query: *

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.

...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 can help me out. My...

If you look at the schema browser in toad at each table you can see the last time it was analyzed on the Stats/Size pane on the right side. You can also analyze the tables by clicking on the calculator icon while highlighting the table name in the schema browser.

OK So I need a point in the right direction. Every month I load several snapshot tables based on end of month data. They are all stored in partitioned tables. At the beginning of each month I have several users running thousands of reports from Business Objects using these tables (amoung...

Thanks Dagon for that Valueble Post.

Great....now I am going to have to pretend I know what I am doing at work. You are very selfish Dave. Congrats on the wedding. It is a wonderful occasion to celebrate. ~Cheers dj

Also are you using UNIX? Is it possible to use Shell to solve your problem? How many rows total are you trying to insert?