About Oracle's Exp_full_database

There are no exp_full_database roles, and the following error occurs:

Ora-31631:privileges are required

Ora-39149:cannot link Privileged user to non-privileged user

Sql> CREATE DATABASE link Pdbl connect to Rman identified by Rman using ' catalog ';

The database link has been created.

--=============================================

C:>EXPDP test2/test2@abc directory=mydir dumpfile=rman.dmp network_link=pdbl tables=t

Export:release 10.2.0.1.0-production on Monday, June, 2011 14:17:37

Copyright (c) 2003, +, Oracle. All rights reserved.

Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Ora-31631:privileges are required

Ora-39149:cannot link Privileged user to non-privileged user

--=============================================

C:>IMPDP TEST2/TEST2@ABC Network_link=pdbl tables=t

Import:release 10.2.0.1.0-production on Monday, June, 2011 14:18:22

Copyright (c) 2003, +, Oracle. All rights reserved.

Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Ora-31631:privileges are required

Ora-39149:cannot link Privileged user to non-privileged user

--=============================================

C:>sqlplus Sys/system@catalog as Sysdba

Sql*plus:release 10.2.0.1.0-production on Monday June 27 15:15:19 2011

Copyright (c) 1982, +, Oracle. All rights reserved.

Connect to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Sql> Grant Exp_full_database to Rman;

The authorization was successful.

Sql>

--=======================================

C:>EXPDP test2/test2@abc directory=mydir dumpfile=rman.dmp network_link=pdbl tables=db

Export:release 10.2.0.1.0-production on Monday, June, 2011 15:15:30

Copyright (c) 2003, +, Oracle. All rights reserved.

Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Starting "TEST2". Sys_export_table_01 ": test2/******** @abc directory=mydir dumpfile=rman.dmp network_link=pdbl tables=db

Estimate in progress using BLOCKS method ...

Processing Object Type Table_export/table/table_data

Total estimation using BLOCKS method:64 KB

Processing Object Type Table_export/table/table

Processing Object Type Table_export/table/index/index

Processing Object Type Table_export/table/constraint/constraint

Processing Object Type Table_export/table/constraint/ref_constraint

. . Exported "RMAN". DB "6.476 KB 1 rows

Master table "TEST2". Sys_export_table_01 "Successfully loaded/unloaded

******************************************************************************

Dump file set for TEST2. SYS_EXPORT_TABLE_01 is:

C:temprman. DMP

Job "TEST2". Sys_export_table_01 "successfully completed at 15:15:43

--===================================

C:>IMPDP test2/test2@abc network_link=pdbl tables=db remap_schema= (RMAN:TEST2)

Import:release 10.2.0.1.0-production on Monday, June, 2011 15:20:56

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45564.htm

Copyright (c) 2003, +, Oracle. All rights reserved.

Connected to:oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Starting "TEST2". Sys_import_table_01 ": test2/******** @abc network_link=pdbl tables=db remap_schema= (RMAN:TEST2)

Estimate in progress using BLOCKS method ...

Processing Object Type Table_export/table/table_data

Total estimation using BLOCKS method:64 KB

Processing Object Type Table_export/table/table

Ora-39151:table "TEST2". DB "exists. All dependent metadata and data is skipped due to table_exists_action of skip

Processing Object Type Table_export/table/index/index

Processing Object Type Table_export/table/constraint/constraint

Processing Object Type Table_export/table/constraint/ref_constraint

Job "TEST2". Sys_import_table_01 "completed with 1 error (s) at 15:21:06

--===============================

--When you create Dblink, the Rman user of Connect remote DB needs to be granted the exp_full_database role, otherwise an error occurs: ORA-39149