Pessoal,

Estou tentando gerar um export de uma tablespace e estou com problemas.

 

$ expdp TABLESPACES=BBS DIRECTORY=EXPORT DUMPFILE=TABLESPACE_BBS.dmp
LOGFILE=TABLESPACE_BBS.log

 

Export: Release 11.2.0.4.0 - Production on Fri Aug 7 10:55:49 2015

 

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

 

Username: system

Password:

 

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 -
64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing
options

ORA-39004: invalid state

ORA-39091: unable to determine logical standby and streams status

ORA-04045: errors during recompilation/revalidation of
SYS.DBMS_STREAMS_DATAPUMP_UTIL

ORA-01775: looping chain of synonyms

ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_STREAMS_DATAPUMP_UTIL"

 

Notei que o objeto SYS.DBMS_STREAMS_DATAPUMP_UTIL esta com erro.

 

SQL> alter package SYS.DBMS_STREAMS_DATAPUMP_UTIL compile body;

alter package SYS.DBMS_STREAMS_DATAPUMP_UTIL compile body

*

ERROR at line 1:

ORA-01775: looping chain of synonyms

 

Alguém poderia dar uma ajuda?

 

Grato,

Ednilson Silva

  • [oracle_br] Erro Da... 'Ednilson Silva' ednilson.si...@jbs.com.br [oracle_br]

Responder a