You can do this:

Fisrt, an user's export without data:
exp userid=system/manager owner=test file = c:\test.dmp rows=n

Then, Open the export file , look after the DDl view command and copy it.

-----Message d'origine-----
De : Deepak Panda
[mailto:oracledba-ezmlmshield-x30159955.[Email address protected]
Envoyé : lundi 31 mai 2004 08:51
À : LazyDBA.com Discussion
Objet : View Definition


Hi Gurus,

Can anybody suggest the EASIEST way to find the definition of a view.

Regards

Deepak


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page