OraFAQ Forum: Server Administration » Trying to export a table that contains blobs

Home » RDBMS Server » Server Administration » Trying to export a table that contains blobs (11.2.0.1)

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

Trying to export a table that contains blobs [message #683613]

Sat, 06 February 2021 11:29

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi Gurus,
Trying to export a table that contains Blobs, I get this error message

SQL> $exp bi/pwd file=d:\dataexp tables=(piece)

Export: Release 11.2.0.1.0 - Production on Sat Feb 6 10:59:01 2021

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                          my_table
EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 4, block # 53397)
ORA-01110: data file 4: 'D:\APP\ORADATA\ORCL\USERS01.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option
Export terminated successfully with warnings.

SQL>

Any help will be appreciated.

Thanks in advance ,

Amine

Report message to a moderator

Re: Trying to export a table that contains blobs [message #683614 is a reply to message #683613]

Sat, 06 February 2021 12:27

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-26040: Data block was loaded using the NOLOGGING option\n
  Cause: Trying to access data in block that was loaded without
         redo generation using the NOLOGGING/UNRECOVERABLE option
  Action: Drop the object containing the block.

[Updated on: Sat, 06 February 2021 12:29]

Report message to a moderator

Previous Topic:	How to IMPDP to PDB?
Next Topic:	Trace non-invokers sessions of a different instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 17:43:39 CST 2025