Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMP_FULL_DATABASE role required

675321Dec 12 2008 — edited Feb 10 2009

Hi,
A strange issue...
I am trying to import atwo tables from one DB to other in solaris but it asks for IMP_FULL_DATABASE role but the target schema has been granted the role already....
Kindly help.........

impdp parfile=/u01/ora10gr2/dolphin/dwh/importUCSDB_DOLPHIN_DMP_20081212081546
+.par+

Import: Release 10.2.0.3.0 - 64bit Production on Friday, 12 December, 2008 8:15:
+46+

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
Master table "DOL_DMP"."DP_IMP_DOL_DMP_20081212081546" successfully loaded/unloa
ded
Starting "DOL_DMP"."DP_IMP_DOL_DMP_20081212081546": parfile=/u01/ora10gr2/dolph
in/dwh/importUCSDB_DOLPHIN_DMP_20081212081546.par
Processing object type TABLE_EXPORT/TABLE/PROCACT_INSTANCE
ORA-39083: Object type PROCACT_INSTANCE failed to create with error:
ORA-26723: user "DOL_DMP" requires the role "IMP_FULL_DATABASE"
Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate(object_owner=>'DOLPHIN3', object_name=>'RVGRUPPE
+', object_type=>'2', export_db_name=>'UCSDB', inst_scn=>'2819167066', ignore_scn+
+=>'2819124206');COMMIT; END;+

My Parfile is .....

USERID=dol_dmp/dol_dmp@ecdcbhs1
JOB_NAME=dp_imp_dol_dmp_20081212122318
DUMPFILE=exportucsdb_DOLPHIN_DMP_%U.dmp
LOGFILE=importUCSDB_DOLPHIN_DMP_20081212122318.log
FULL=N
PARALLEL=2
DIRECTORY=DP_EXPORT_DIR
+#EXCLUDE=STATISTICS+
TABLE_EXISTS_ACTION=TRUNCATE
+# TABLE_EXISTS_ACTION=REPLACE+
INCLUDE=TABLE:"IN ('ZAHLUNGSEMPFANG','RVGRUPPE')"
REMAP_SCHEMA=dolphin3_t:dol_dmp transform=oid:n
+#REMAP_TABLESPACE=PHIN_DATA1:DOL_DATA PHIN_IDNX:DOL_IDX+

Any suggestions????????????????

Edited by: user10707066 on Dec 12, 2008 3:30 AM