Database Utilities (MOSC)

MOSC Banner

Expdp error while trying to exclude grants to a particular schema

edited Feb 9, 2013 3:02AM in Database Utilities (MOSC) 3 commentsAnswered
Hi all,

I'm get getting error while taking export of a schema in Transportable_tablespace mode excluding some grants 
to/from a particular schema.

All the objects of the schema (grant_test) are in the GRANT_TEST_TBLSP tablespace. 

The content of the parameter file [GRP.PAR] is as follows:
---------
DUMPFILE=GR.DMP
DIRECTORY=DIR_GRANT_TEST
TRANSPORT_FULL_CHECK=Y
TRANSPORT_TABLESPACES=
EXCLUDE=STATISTICS
EXCLUDE=GRANT:"='SCOTT'"
---------

The content of the generated log file [export] while taking the export is as follows: 
---------
;;; 
Export: Release 10.2.0.3.0 - Production on Sunday, 03 February, 2013 16:42:47

Copyright (c) 2003, 2005, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center