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