Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Show last executed "create table as" SQL's

user12068228May 7 2010 — edited May 7 2010
Hi
I'm searching for the DDL-SQL's with which some tables were created yesterday (create table as select...).
The problem is that this was complex code which went lost. In the Views like v$sql I only can find the usual SQL-Statements from yesterday (select...) but no "create" statements.
Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2010
Added on May 7 2010
6 comments
951 views