Sun Cluster 3.0 commands

2004-01-26 Thread oranew2004 


Hi All!
I looking for commands which I could use to check Sun Cluster health ( like resources, groups...) I think I would able run them as an Oracle user. 
 
Thanks.
Greg
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!

Re: simple question

2004-01-08 Thread oranew2004 
CREATE OR REPLACE PROCEDURE labware_admin.truncate_tables(    schema_owner    IN VARCHAR2) AS
   r number(10);
BEGIN
FOR r IN (SELECT table_name FROM dba_tables WHERE owner=schema_owner)  LOOP    EXECUTE IMMEDIATE 'truncate table schema_owner.'||r.table_name;  END LOOP;
END;  
 
 
ERROR:  Line 14 Column 55 PLS-00364: loop index variable 'R' use is invalid.
 
 
Any ideas?
 
Thank you!
 
 
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes