This discussion is archived
1 Reply Latest reply: Jan 20, 2013 10:10 PM by Niket Kumar RSS

EXPDP error EXP-00068

KSG Explorer
Currently Being Moderated
Hi,

Oracle 10.2.0.4.0 on Windows

I'm getting the belwo error

EXP-00068: tablespace SYSAUX is offline.

When I check the Tablespace status, it's Online and Datafile status is Available.

I found the SYSAUX tablespace requires recovery.

select a.file#, a.name, a.status
from v$datafile a, v$tablespace b
where a.ts#=b.ts#
and b.name='SYSAUX';

The SYSAUX datafile show status as recovery.
Regards
KSG

Edited by: KSG on Jan 21, 2013 12:00 PM
(findings)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points