OraFAQ Forum: Server Utilities » Privilege issue when running impdp with transportable tablespace

Home » RDBMS Server » Server Utilities » Privilege issue when running impdp with transportable tablespace (Oracle11gR1, RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Privilege issue when running impdp with transportable tablespace [message #403996]

Wed, 20 May 2009 00:12

bbmonster
Messages: 47
Registered: June 2007
Location: UB

Member

Hello,

I am trying to attach transportable tablespace created in Oracle 10g into Oracle 11g. Both oracle are same X86_64 system.

Also granted
* EXP_FULL_DATABASE
* IMP_FULL_DATABASE

roles to the user. but I still receiving this error:

ORA-31631: privileges are required
ORA-39162: Transportable tablespace job require privileges

[oracle@test-db1 MYSPC_20090514]$ impdp mediator/MEDIATOR dumpfile=MYSPC_20090514.dmp DIRECTORY=tts_test_1 
TRANSPORT_DATAFILES=/home/oracle/tablespaces/10gTs/disk7/backup/preptts/MYSPC_20090514/TESTS_set693_piece1_20090514_data_D-TESTS_I-1502757570_TS-MYSPC_FNO-73_llkf08t1,
/home/oracle/tablespaces/10gTs/disk7/backup/preptts/MYSPC_20090514/TESTS_set694_piece1_20090514_data_D-TESTS_I-1502757570_TS-MYSPC_FNO-308_lmkf097r

Import: Release 11.1.0.6.0 - Production on Wednesday, 20 May, 2009 12:56:03

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: privileges are required
ORA-39162: Transportable tablespace job require privileges

Can someone help to solve this problem?

Thanks in advance,

bbmonster

[Updated on: Wed, 20 May 2009 01:08] by Moderator

Report message to a moderator

Re: Privilege issue when running impdp with transportable tablespace [message #404043 is a reply to message #403996]

Wed, 20 May 2009 03:26

bbmonster
Messages: 47
Registered: June 2007
Location: UB

Member

Hi all,

I solved the problem. I think it was default role problem.

CREATE ROLE tts_role;
GRANT create session, create table TO tts_role;
GRANT read, write ON DIRECTORY tts_test_1 TO tts_role;
GRANT tts_role TO mediator;
ALTER USER mediator DEFAULT ROLE all;

Thanks

Report message to a moderator

Re: Privilege issue when running impdp with transportable tablespace [message #404069 is a reply to message #404043]

Wed, 20 May 2009 04:41

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Thanks for the feedback it is worth to keep in mind that roles must be enable by default.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-01406: fetched column value was truncated
Next Topic:	Error of Import [Full=Y]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 03:12:51 CDT 2024