Home » RDBMS Server » Server Utilities » Error while taking the backup of table containing blob database
Error while taking the backup of table containing blob database [message #302319] Mon, 25 February 2008 04:19 Go to next message
mali2602
Messages: 2
Registered: February 2008
Junior Member
Hi Gurus,

I am trying to export DB, If exports fine for all other table, Except the table containing blob datatype

I am getting this type of error

EXP-00056:ORACLE error 1555 encountered
ORA-01555:snapshot too old: rollback segment number with name '''' too small
ORA-22924:snapshot too old

Please help me to resolve this problem,

Thanks in advance
Re: Error while taking the backup of table containing blob database [message #302332 is a reply to message #302319] Mon, 25 February 2008 04:46 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export when there is no modification in your database on remove the consistent=y option (with the consequences you can have).

By the way, export is NOT a backup utility.

Regards
Michel

[Updated on: Mon, 25 February 2008 04:46]

Report message to a moderator

Previous Topic: SQL Loader Problem
Next Topic: SQL Loader Error (merged)
Goto Forum:
  


Current Time: Sat Dec 10 16:20:55 CST 2016

Total time taken to generate the page: 0.09264 seconds