Re: Need scripts for db objects for a database

anindya wrote:
> Hi,
>
> I am using Oracle 9i in my project. I want to get all the database
> object scripts for a particular database. What would be best way to do
> it?
>
> Thanks,
> anindya

What do you mean by "get all the ... scripts"? Do you mean create scripts to rebuild the schemas or gather up every perl and shell script littering the operating system disks?

Your intent is less than clear.

If create scripts then as Michel recommends ... use the pipelined table function DBMS_METADATA.GET_DDL. You will find a tutorial demo in Morgan's Library at www.psoug.org.

-- 
Daniel Morgan
Puget Sound Oracle Users Group