1 Reply Latest reply on Jan 21, 2013 6:10 AM by Niket Kumar

    EXPDP error EXP-00068


      Oracle 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.

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