Any Sample ksh script to validate all the database objects

Hi,

I need a sample script to validate all the database objects like

  1. table structure(columns, datatypes,key contraints if any)
  2. synonyms
  3. grants
  4. indexes
    ....etc

thank you!

And ?

  1. table name and schema name should be passed as input parameters to the script
  2. taking those inputs it should validate all the database objects
  3. after validating it should write to a .csv or excel file
    writing output should be like this
    SELECT table_name, column_name, data_type, data_length, nullable
    FROM all_tab_columns
    WHERE table_name IN ('$TABLE_NAME') AND owner IN ('$OWNER_NAME')
    ORDER BY column_id;