Hi Ashish,

I have used the attached one recently. You could add recreation of other
objects
- tables, views, procedures etc...

(The daemon rejected the message so I had to zip the script)

HTH

Evgueni Balabanov, DBA
Oracle LazyDBA home page