Home » RDBMS Server » Server Utilities » Backup determination ( , SunOS)
Backup determination [message #537851] Mon, 02 January 2012 00:07 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Is there a way to know what kind of Backup (table/tablespace/full/schema) by looking
at export dump file ? If yes, can you tell me the command ?

[Updated on: Mon, 02 January 2012 00:09]

Report message to a moderator

Re: Backup determination [message #537856 is a reply to message #537851] Mon, 02 January 2012 01:05 Go to previous message
Messages: 21802
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think not, except for using SHOW=Y (but this might be a very lengthy listing and I'm not sure you'd find out information you are looking for).

However: if you open a DMP file in a text editor (which is capable of opening rather large files; I wouldn't expect it to successfully open 30GB DMPs. I have problems opening a 250 MB file), at the beginning you'd see something like the following screenshot:


As you can see, this *might* be what you are looking for. The first EXP.DMP really exported a few tables only, while SCOTT.DMP contains export of the whole SCOTT's schema (i.e. user).

Someone might know better, though.
  • Attachment: exp_type.png
    (Size: 18.55KB, Downloaded 1767 times)
Previous Topic: Primary keys are not exporting when export using EXP command
Next Topic: Import from 10g backup to 9i DB
Goto Forum:

Current Time: Fri Feb 23 13:45:54 CST 2024