OraFAQ Forum: Server Utilities » Backup determination

Home » RDBMS Server » Server Utilities » Backup determination (10.2.0.4.0 , SunOS)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Backup determination [message #537851]

Mon, 02 January 2012 00:07

balaji14
Messages: 252
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

Littlefoot
Messages: 17256
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 72 times)

Report message to a moderator

Previous Topic:	Primary keys are not exporting when export using EXP command
Next Topic:	Import from 10g backup to 9i DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 20:27:49 CDT 2013

Total time taken to generate the page: 0.13887 seconds