Home » RDBMS Server » Server Utilities » Questions on data pump (Oracle 10.2.0.4.0, SunOS)
Questions on data pump [message #536804] Fri, 23 December 2011 02:45 Go to next message
Jack14
Messages: 451
Registered: December 2011
Location: INDIA
Senior Member
Hi,

1.I used the following query to see if the user 'TEST' has read,write privilege on directory objects and the output it was as below.

SELECT p.grantee, p.privilege, p.owner, d.directory_name
 FROM dba_tab_privs p, dba_directories d
WHERE p.table_name=d.directory_name
  AND (grantee IN ('TEST', 'PUBLIC')
       OR grantee IN (SELECT granted_role FROM dba_role_privs
                       WHERE grantee IN ('TEST', 'PUBLIC')))
ORDER BY 4,3,2;

     GRANTEE	      PRIVILEGE OWNER	DIRECTORY_NAME
EXP_FULL_DATABASE	WRITE	SYS	DATA_PUMP_DIR
IMP_FULL_DATABASE	WRITE	SYS	DATA_PUMP_DIR
EXP_FULL_DATABASE	READ	SYS	DATA_PUMP_DIR
IMP_FULL_DATABASE	READ	SYS	DATA_PUMP_DIR



From the above output , i see column grantee has 'EXP_FULL_DATABASE' instead of 'TEST' user. can you explain about this?

2.Can you explain the relationship pertaining to tablespace on data pump?

Also why do we check whether user TEST has quota on which tablespaces in data pump?

Could you clarify the above questions?

Thank you



Re: Questions on data pump [message #536806 is a reply to message #536804] Fri, 23 December 2011 02:55 Go to previous messageGo to next message
Michel Cadot
Messages: 57604
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
can you explain about this?

Comes from
Quote:
OR grantee IN (SELECT granted_role FROM dba_role_privs
WHERE grantee IN ('TEST', 'PUBLIC')))


Quote:
Can you explain the relationship pertaining to tablespace on data pump?


I don't understand the sentence.

Quote:
Also why do we check whether user TEST has quota on which tablespaces in data pump?


If you want to import physical objects in TEST schema, TEST must have quota on the target tablespace of the objects.

Is this an interview or homework question?

Regards
Michel
Re: Questions on data pump [message #536811 is a reply to message #536806] Fri, 23 December 2011 03:12 Go to previous message
Jack14
Messages: 451
Registered: December 2011
Location: INDIA
Senior Member
Michel,

Quote:
Can you explain the relationship pertaining to tablespace on data pump?

Also why do we check whether user TEST has quota on which tablespaces in data pump?



Both the above questions are similar .Sorry for confusing.

Quote:

Is this an interview or homework question?


Homework question.

Thank you very much for your responds.

[Updated on: Fri, 23 December 2011 03:12]

Report message to a moderator

Previous Topic: SQL Loader Comma delimiter issue
Next Topic: Parallel slaves on import
Goto Forum:
  


Current Time: Thu Apr 17 03:36:25 CDT 2014

Total time taken to generate the page: 0.09783 seconds