Expdp: ORA-31693 + ORA-01031 – GPO (Grupo de Profissionais Oracle)

11 de novembro de 2011 às 3:21 pm #101592

rman

Participante

@felipeg

Verifiquei, os 3 usuários datapump estão com as mesmas permissões:

SQL> select * from session_privs order by 1;


PRIVILEGE
ADMINISTER DATABASE TRIGGER

ADMINISTER RESOURCE MANAGER

ALTER ANY PROCEDURE

ALTER ANY TABLE

ALTER ANY TRIGGER

ALTER ANY TYPE

ANALYZE ANY

AUDIT ANY

BACKUP ANY TABLE

BECOME USER

COMMENT ANY TABLE

CREATE ANY CLUSTER

CREATE ANY CONTEXT

CREATE ANY DIMENSION

CREATE ANY DIRECTORY

CREATE ANY INDEX

CREATE ANY INDEXTYPE

CREATE ANY LIBRARY

CREATE ANY MATERIALIZED VIEW

CREATE ANY OPERATOR
PRIVILEGE
CREATE ANY PROCEDURE

CREATE ANY SEQUENCE

CREATE ANY SQL PROFILE

CREATE ANY SYNONYM

CREATE ANY TABLE

CREATE ANY TRIGGER

CREATE ANY TYPE

CREATE ANY VIEW

CREATE DATABASE LINK

CREATE PROFILE

CREATE PUBLIC DATABASE LINK

CREATE PUBLIC SYNONYM

CREATE ROLE

CREATE ROLLBACK SEGMENT

CREATE SESSION

CREATE TABLESPACE

CREATE USER

DROP ANY CLUSTER

DROP ANY CONTEXT

DROP ANY DIMENSION

DROP ANY DIRECTORY
PRIVILEGE
DROP ANY INDEX

DROP ANY INDEXTYPE

DROP ANY LIBRARY

DROP ANY MATERIALIZED VIEW

DROP ANY OPERATOR

DROP ANY OUTLINE

DROP ANY PROCEDURE

DROP ANY ROLE

DROP ANY SEQUENCE

DROP ANY SQL PROFILE

DROP ANY SYNONYM

DROP ANY TABLE

DROP ANY TRIGGER

DROP ANY TYPE

DROP ANY VIEW

DROP PROFILE

DROP PUBLIC DATABASE LINK

DROP PUBLIC SYNONYM

DROP ROLLBACK SEGMENT

DROP TABLESPACE

DROP USER
PRIVILEGE
EXECUTE ANY PROCEDURE

EXECUTE ANY TYPE

GLOBAL QUERY REWRITE

INSERT ANY TABLE

MANAGE ANY QUEUE

READ ANY FILE GROUP

RESUMABLE

SELECT ANY SEQUENCE

SELECT ANY TABLE

UPDATE ANY TABLE

72 rows selected