I want to take only the database objects DDL(Table definitions(except data),views,procedures,functions,Macros) from a database using ARCMAIN.I don't want to mention all the object's names in the ARCMAIN script(becuase we are having 600 Tables,300 Macros and 185 views).
Re: Backup All database objects only without data....
From the Database Administration manual:
"A dictionary table archive contains all table, view, macro and trigger definitions in the database, and dictionary entries for stored procedures and user-defined functions. A restore of a dictionary archive restores the definitions of all data tables, views, macros, triggers, and stored procedures. However, it does not restore any data."
To accomplish a dictionary table archive review the ARCHIVE command in the Archive/Recover Utility manual.
The following command should be pretty close to what you are looking for: