-
table
I created a table instead of view based on a select stmt .I didn't saved the select stmt.
now i cannot see the original stmt in OEM like view.
is there any way we can get the select stmt i used with when i created that table
i used create table demo_table as select ...
is it possible?
-
Did you check in v$SQL?
Tamil
-
thanks, no i was not able find .I created this like 20 days ago...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|