Sun Cluster 3.0 commands
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
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