Quote Originally Posted by PAVB
No, you can't.
What you can do is import with options SHOW=Y and ROWS=N to a file; view the file and take your DDL from there.
Ok, what kind of file do you mean?
The view "test" of the schema "test_schema" was deleted. I import one backup with following parfile.ora:
Code:
userid=*/*@testdb
fromuser=test_schema
touser=test_schema
show=y
rows=n
Ok, what is happen now? The deleted view is not available within the schema, or anywhere else.

Regards