Recent content by mikedaruke

Hi, I am getting alot of errors in the messages log, Unable to SCSI unload drive. Drives are constantly going down. They are ndmp drives that are controlled by nas devices. I am not sure what the problem is or where to look Thanks Mike

Doesn't work, it still goes from the first _ rather then the last one.

I have a string $string = 'I_Love_Perl_So_Much'; I want to capture the 'Much' word, or the last match for _.*?$ I am currently doing $string =~ m/_(.*?)/; but it finds _Love_Perl_So_Much How can I get perl to search from the Left to the Right instead of Right to Left? Thanks

Dagon, I am not set on triggers or think its right! Thats what I am asking for advice. Hmm a Pl SQL script, I didnt think of that. That sounds like a good idea. The views just relie on each other and I have them set to refresh once a day. So I never did any PL SQL script, can you give me a...

Hello, I am not sure if this is the correct way to do this or not, I am trying to have my views update one after another. With the basis being one view relies on another. Currently I have them setup to update at a certain time, but if one of the views take longer then expected things get...

I did all that already, and tried all the troublshooting and nothing worked.

Receiving error 800 when trying to backup to disk. I am just backing up a directory on a media server to another directory on the same media server. any ideas?

If I log onto a Solaris box, how do I tell the difference between local or san attached storage? I would like to know which filesystems are local and which are SAN. This way I can move some important directories to SAN. Thanks

Can someone write me a stored procedure that updates a materialized view? Reason is I am trying to use perl to update the view, via cron, and it gives me errors, so I am thinking maybe just running a stored procedure to update it. Any ideas?

Anyone know how I can have perl update materialized views in Oracle? I know the command do it via SQL* Plus, but not sure how to do it via the DBI module. I am currently connected and can run SQL against the DB and get results. Any ideas? Want to execute. execute...

How can I run multiple update statments at once? I have 9k to run. I tried Update ... ; Update ... ; But it just freezes

no that would get me the min and max. I need the next day, based off the last date.

sorry wrong query, here it is, it works if i put a client name in, well some of them, some take to long to come back. I need it to be faster or it will never work with temp1 as( select * from table1 where client_name = 'Bob' ) select * from temp1 a, temp1 b where b.s_date = (select max(s_date)...

select client_name, store_name, product_date, s_date , b.s_date "return_date" from table1 a, table1 b where b.s_date = (select min(start_date) return_date from table1 where start_date > a.start_date)

I need some help taking a table with the following Client_name, Store_name, product, date Bob, Joes Cars, Oil, 3/01/08 Bob, Joes Cars, Oil, 4/07/08 Bob, Joes Cars, Oil, 5/08/08 Bob, Joes Cars, Oil, 5/25/08 Bob, Joes Cars, Oil, 6/10/08 Chris,Joes Cars, Oil, 3/10/08 Chris,Joes Cars, Oil, 3/28/08...