asked on

impdp ora-1031

Hi
I am trying to imp using network link

i am getting a error ora-1031

ORA-31693: Table data object "SCOTT"."MKT" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
ORA-02063: preceding line from db_link

But i can select * from MKT@db_link

could some one pls advice,thx
sushil

Shaju Kumbalath

Can u post the import log file?

sushilt

ASKER

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "NAV"."SYS_IMPORT_TABLE_01": nav/******** directory=nav_imp_dir tables=nav.markets network_link=udbha01_udb003_xap table_exists_action=replace
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1024 KB
Processing object type TABLE_EXPORT/TABLE/PROCACT_INSTANCE
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-31693: Table data object "NAV"."MARKETS" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
ORA-02063: preceding line from UDBHA01_UDB003_XAP
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Job "NAV"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 04:58:39

ASKER CERTIFIED SOLUTION

Shaju Kumbalath

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sushilt

ASKER

FLASHBACK ANY TABLE privilege to allow export/import on all tables.
should i say this in the target database or in the database where i am running import

Shaju Kumbalath

The user which network link connects (remote user) should have FLASHBACK ANY TABLE privillege

sushilt

ASKER

I granted FLaskback any table to remote user,still getting the above mentioned same error

Shaju Kumbalath

have u granted the privillege to the user which is mention in dblink?