Home » RDBMS Server » Server Utilities » Privilege issue when running impdp with transportable tablespace (Oracle11gR1, RHEL5)
Privilege issue when running impdp with transportable tablespace [message #403996] Wed, 20 May 2009 00:12 Go to next message
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

icon7.gif  Re: Privilege issue when running impdp with transportable tablespace [message #404043 is a reply to message #403996] Wed, 20 May 2009 03:26 Go to previous messageGo to next message
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
Re: Privilege issue when running impdp with transportable tablespace [message #404069 is a reply to message #404043] Wed, 20 May 2009 04:41 Go to previous message
Michel Cadot
Messages: 64152
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
Previous Topic: ORA-01406: fetched column value was truncated
Next Topic: Error of Import [Full=Y]
Goto Forum:
  


Current Time: Sat Dec 10 14:58:28 CST 2016

Total time taken to generate the page: 0.04481 seconds