OraFAQ Forum: Backup & Recovery » Problem during export backup of a particular table

Home » RDBMS Server » Backup & Recovery » Problem during export backup of a particular table

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

Problem during export backup of a particular table [message #226953]

Tue, 27 March 2007 00:29

pradeep.ramana
Messages: 12
Registered: March 2007

Junior Member

Hi all,

While i was taking a export backup of a particular table having partitions the export backup was terminated unsuccesfully for the last partition because of some space problem.

Can anyone tell wether i can use the export backup of remaining partitions for importing?

Thanks in Advance
Regards,

Report message to a moderator

Re: Problem during export backup of a particular table [message #226973 is a reply to message #226953]

Tue, 27 March 2007 00:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You'll know the answer after you do the import & see the results.
QED!

Report message to a moderator

Re: Problem during export backup of a particular table [message #226975 is a reply to message #226953]

Tue, 27 March 2007 00:44

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

some space problem

can you post exact error output which your getting during export.

regards
Taj

Report message to a moderator

Re: Problem during export backup of a particular table [message #227017 is a reply to message #226975]

Tue, 27 March 2007 02:40

pradeep.ramana
Messages: 12
Registered: March 2007

Junior Member

EXP-00002:ERROR IN WRITTING TO EXPORT FILE

Report message to a moderator

Re: Problem during export backup of a particular table [message #227019 is a reply to message #227017]

Tue, 27 March 2007 02:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
EXP-00002:ERROR IN WRITTING TO EXPORT FILE

Is there any premission problem.

and also post what command your using for export.
regards
Taj

Report message to a moderator

Re: Problem during export backup of a particular table [message #227024 is a reply to message #227019]

Tue, 27 March 2007 02:52

pradeep.ramana
Messages: 12
Registered: March 2007

Junior Member

Hi,

There's no permission problem, and i'm using a export utility of toad.

At the time of exporting last partition data error occured i want to know can i use previouse partitons data for import.

Regards,
Pradeep

Report message to a moderator

Re: Problem during export backup of a particular table [message #227026 is a reply to message #227024]

Tue, 27 March 2007 02:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

You'll know the answer after you do the import & see the results

you should try...

regards
Taj

Report message to a moderator

Previous Topic:	problem in undo file
Next Topic:	Oracle 9i -> Oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 12:46:08 CDT 2024