Menu
I have an oracle full dump. I know I have to imp the dump with the fromuser touser clause. However I don't know the names of the schemas included in the dump.
how can I open the dump created with Oracle 10g just to check and analyze the content?
594
SHOW=y option of the IMP utility allows you to see the content of an Oracle dump/export file (. dmp). When this option is specified, IMP outputs the SQL statements contained in the export file in the order in which Import will execute them.
The export dump file includes the metadata for objects contained within the user-defined tablespaces and both the metadata and data for user-defined objects contained within the administrative tablespaces, such as SYSTEM and SYSAUX .
Oracle dump file (. DMP) is a binary storage used by Oracle users and database administrators to backup data. Oracle distribution pack includes the standard tool EXP for this purpose. The problem is that Oracle dump file is a "black box" and there is no way to extract data from such files except the standard IMP tool.
Just use the SHOW=Y parameter
IMP SCOTT/TIGER SHOW=Y FILE=import_file.dmp
if you are working in a UNIX environment, you may use command strings to show readable information from the dump files.
strings test.dmp|grep CREATE.*TABLE
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
