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

Hi,

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
Littlefoot
Messages: 19305
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:

./fa/9692/0/

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 98 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: Thu Jul 24 10:32:41 CDT 2014

Total time taken to generate the page: 0.10024 seconds