How to find view creation date and time

From: DL <donlcs_at_yahoo.com>
Date: 18 Dec 2002 09:17:24 -0800
Message-ID: <604bb90c.0212180917.204622a4_at_posting.google.com>

Hello,

We're on Oracle 9i for Windows.
I have no problem finding all the views available to the current user, but how can I find each view's creation date and time? I can't determine it by merely looking at the SQL statement for "all_views" sys object. Thanks.

Don Received on Wed Dec 18 2002 - 18:17:24 CET

This message: [ Message body ]
Next message: Chris Leonard: "Re: How to find view creation date and time"
Previous message: Michael: "ORA-01000 Max. No. of Open Cursors Exceeded in Function"
Next in thread: Chris Leonard: "Re: How to find view creation date and time"
Reply: Chris Leonard: "Re: How to find view creation date and time"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message