Home » RDBMS Server » Server Utilities » Export Error (Red Hat AS 4.6 64bit, DB 10.2.0.4)
Export Error [message #504628] Tue, 26 April 2011 22:48 Go to next message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
Hi,

I want to export all db using data pump. I got this error when using it:

Export: Release 10.2.0.4.0 - Production on Thu Nov 25 11:46:48 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export the entire database ...
. exporting tablespace definitions
EXP-00068: tablespace TISDATA is offline
EXP-00008: ORACLE error 1187 encountered
ORA-01187: cannot read from file 203 because it failed verification tests
ORA-01110: data file 203: '/u03/app/oracle/product/10.2.0/oradata/unidev/TISTEMP01.dbf'
EXP-00000: Export terminated unsuccessf


Can anyone explain what mean by that error?

Thanks,
BaniE.

[Updated on: Tue, 26 April 2011 23:07]

Report message to a moderator

Re: Export Error [message #504629 is a reply to message #504628] Tue, 26 April 2011 22:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
00068, 00000, "tablespace %s is offline"
// *Cause: Export failed to export tablespace (tablespace being offline).
// *Action: Make tablespace online and re export.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Tue, 26 April 2011 22:54]

Report message to a moderator

Re: Export Error [message #504630 is a reply to message #504629] Tue, 26 April 2011 23:14 Go to previous message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
Edited.
Previous Topic: export stopped
Next Topic: Export/Import errors
Goto Forum:
  


Current Time: Fri Mar 29 10:41:32 CDT 2024