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

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 23:11:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.