IMPDP avec NETWORK_LINK et ORA-39149
Bonjour,
Je "tente" de faire un import via datapump et un network_link. Mais je suis bloque de maniere epaisse avec l'erreur:
Code:
1 2
| ORA-31631: privileges are required
ORA-39149: cannot link privileged user to non-privileged user |
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| C:\>sqlplus tmp2/xxxx
SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 19 16:54:31 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP and Real Application Testing options
TMP2@minilhc >select 1 from dual@test2;
1
----------
1 |
Donc j'ai une base sur mon PC windows, et je voudrais faire un import depuis une base distante avec le dblink test2.
La base distante:
Code:
1 2 3 4 5 6 7 8 9 10 11
| $ rlwrap sqlplus tmp/xxxx
SQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 19 16:58:11 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning option
TMP> |
Du coup, j'essaye un impdp avec le network, ca eviterait de faire un dump, le transferer, et patati-patata. Ce sera surement pratique une fois que j'arriverai a m'en servir correctement en fait.
Code:
1 2 3 4 5 6 7 8 9 10
| C:\>impdp tmp2/xxxx directory=data_pump_dir network_link=perftest2 remap_schema=tmp:tmp2;
Import: Release 11.2.0.1.0 - Production on Wed Oct 19 16:35:34 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP and Real Application Testing options
ORA-31631: privileges are required
ORA-39149: cannot link privileged user to non-privileged user |
Afin de voir les differences entre les deux, j'ai mis ces quelques requetes, mais elles me renvoient toutes no rows selected. du coup je ne sais pas trop ou chercher.
Code:
1 2 3 4 5 6
| select table_name, grantor, privilege from user_tab_privs@test2 minus select table_name, grantor, privilege from user_tab_privs;
select table_name, grantor, privilege from user_tab_privs minus select table_name, grantor, privilege from user_tab_privs@test2;
select privilege from user_sys_privs minus select privilege from user_sys_privs@test2;
select privilege from user_sys_privs@test2 minus select privilege from user_sys_privs;
select granted_role from user_role_privs minus select granted_role from user_role_privs@test2;
select granted_role from user_role_privs@test2 minus select granted_role from user_role_privs; |
Si quelqu'un a une idee ou un pointeur, ce serait top :D