how to take Defitions of objects??

Hello All,

I need definitions of all tables, views, functions, store procedures etc... of a particular user..


I mean how can i take all tables, view, functions, store procedures creation scrits....


can any one guide me?

you need to get the details of all the tabls,views,..etc related to a specific user ??
or you need to extract the tables,view,procedures owned by a specific user?

Lots of ways...
1- Resort to a reverse engineering enabled product like ERWin
2- Query the appropriate system views
3- Export the user with rows=no option then just import it or import it to a file with show=y option
4- Extract the objects using any fancy GUI based product like DBArtisan, etc.