Home » RDBMS Server » Backup & Recovery » Problem during export backup of a particular table
Problem during export backup of a particular table [message #226953] Tue, 27 March 2007 00:29 Go to next message
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,
Re: Problem during export backup of a particular table [message #226973 is a reply to message #226953] Tue, 27 March 2007 00:42 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You'll know the answer after you do the import & see the results.
QED!
Re: Problem during export backup of a particular table [message #226975 is a reply to message #226953] Tue, 27 March 2007 00:44 Go to previous messageGo to next message
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
Re: Problem during export backup of a particular table [message #227017 is a reply to message #226975] Tue, 27 March 2007 02:40 Go to previous messageGo to next message
pradeep.ramana
Messages: 12
Registered: March 2007
Junior Member
EXP-00002:ERROR IN WRITTING TO EXPORT FILE
Re: Problem during export backup of a particular table [message #227019 is a reply to message #227017] Tue, 27 March 2007 02:42 Go to previous messageGo to next message
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
Re: Problem during export backup of a particular table [message #227024 is a reply to message #227019] Tue, 27 March 2007 02:52 Go to previous messageGo to next message
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
Re: Problem during export backup of a particular table [message #227026 is a reply to message #227024] Tue, 27 March 2007 02:56 Go to previous message
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
Previous Topic: problem in undo file
Next Topic: Oracle 9i -> Oracle 10g
Goto Forum:
  


Current Time: Sat Dec 03 13:55:12 CST 2016

Total time taken to generate the page: 0.14487 seconds