| Author |
View Oracle exp file
|
|
| Diego B. 2005-10-20, 8:25 pm |
| Hi,
Do you know if there is any possibility to view an Oracle database
schema exported in a file with the "exp" command without importing it
back to a database?
Thank you in advance for every possible suggestion!
Diego.
| |
| Ben Graham 2005-10-20, 8:25 pm |
| Open the dump file in a text editor. You'll see the DDL in plain text.
Best not to use notepad if the dmp file is big.
| |
| rogergorden@gmail.com 2005-10-20, 8:25 pm |
| Actually,
SHOW=Y is a better bet.
Roger Gorden
Sr. DBA Unicast Corporation
| |
| Mark D Powell 2005-10-20, 8:25 pm |
| Roger and Diego, I think you may find the indexfile parameter a better
bet as it formats the DDL into an almost usable format. You just need
to remove the comments.
IMHO -- Mark D Powell --
| |
| rogergorden@gmail.com 2005-10-20, 8:25 pm |
| Thanks. That's even better then my answer.
Roger Gorden
Sr. DBA Unicast Corporation
|
|
|
|