Home » RDBMS Server » Server Administration » Trying to export a table that contains blobs (11.2.0.1)
Trying to export a table that contains blobs [message #683613] Sat, 06 February 2021 11:29 Go to next message
Amine
Messages: 341
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
Re: Trying to export a table that contains blobs [message #683614 is a reply to message #683613] Sat, 06 February 2021 12:27 Go to previous message
Michel Cadot
Messages: 67988
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Sat Oct 16 00:58:40 CDT 2021