SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

SQL> create user u1 identified by u1;

User created.

SQL> grant connect,resource to u1;

Grant succeeded.

SQL> grant select on test.test to u1;

Grant succeeded.

SQL> conn u1/u1
Connected.
SQL> select count(*) from test.test;

COUNT(*)
----------
16036

SQL>

expdp system/sys directory=pumpdir file=u1.dmp logfile=u1exp.log schemas=u1

impdp system/sys directory=pumpdir file=u1.dmp logfile=u1imp.log remap_schema=u1:u2

sqlplus / as sysdba

SQL> alter user u2 identified by u2;

User altered.

SQL> conn u2/u2
Connected.
SQL> select count(*) from test.test;
select count(*) from test.test
*
ERROR at line 1:
ORA-00942: table or view does not exist

ITPub博客

Datapump Does not Export Permissions on Other Schema

最新文章