Expdp: ORA-31693 + ORA-01031

[felipegParticipante]

Opa,

O grant libera a permissão o uso da funcionalidade de flashback sobre as tabelas que não sejam as do usuário.

É uma das recoemndações conforme a documentação da Oracle (Using flashback features):


Grant flashback privileges to users, roles, or applications that need to use flashback features, as follows:
DBMS_FLASHBACK package - Grant EXECUTE privilege on DBMS_FLASHBACK to provide access to the features in this package.
Flashback Query and Flashback Version Query - Grant FLASHBACK and SELECT privileges on specific objects to be accessed during queries, or grant the FLASHBACK ANY TABLE privilege to allow queries on all tables.
Flashback Transaction Query - Grant the SELECT ANY TRANSACTION privilege.
Execution of undo SQL code - Grant SELECT, UPDATE, DELETE, and INSERT privileges for specific tables, as appropriate, to permit execution of undo SQL code retrieved by a Flashback Transaction Query.

http://download.oracle.com/docs/cd/B137 … fns_fl.htm

Atenciosamente,
Felipe.