SQL & PL/SQL

My oracle version is 11.

I want to prepare a DDL scripts for all the below mentioned objects ..

1. Tables with all options

2. Views

3. Types

4. Indexes

5. Packages / Procedures / Functions/ Triggers – Only object name

6. Triggers – Trigger Source

7. Grants to other schemas – other than PSUSR, PSQRYUSR,PSAPEX & PSBROWUSR

8. Materialized Views

9. Sequences

10. Directories

11. JAVA Objects

12. Schedulers List



I have tried package select dbms_metadata.get_ddl(table_name) from dual; which fetches single table and in which i have to mention each table name but i even tried like this
select dbms_metadata.get_ddl('a.table_name) from user_tables but its not working i dont know as where i am going wrong and its throwing this error ..


ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_DDL'
06553. 00000 - "PLS-%s: %s"
*Cause:
*Action:

Kindly give your ideas.. Thanx too ..

For other objects like triggers its i know as i have to use get_dependant_ddl but its not just one object its i have to fetch all objects which are available in the particular schema ..

Rgds,
Nitesh pareek.