This content has been marked as final. Show 6 replies
Syntax and Description
EXCLUDE=object_type[:name_clause] [, ...]
The object_type specifies the type of object to be excluded. To see a list of valid values for object_type, query the following views: DATABASE_EXPORT_OBJECTS for full mode, SCHEMA_EXPORT_OBJECTS for schema mode, and TABLE_EXPORT_OBJECTS for table and tablespace mode. The values listed in the OBJECT_PATH column are the valid object types.
All object types for the given mode of export will be included in the export except those specified in an EXCLUDE statement. If an object is excluded, then all of its dependent objects are also excluded. For example, excluding a table will also exclude all indexes and triggers on the table.
Hi 705159 ,
Thank you for your reply.
I m familiar with the EXCLUDE option. I need everything(tables,objects,synonyms and all that is there) except the roles and that too only certain roles.
Initially I figured out that I would do content=data_only and then apply all the metadata But found out that it is leads to same point.
I have to manually go revoke all the CONNECT,RESOURCE and DBA roles for certain users.
EXCLUDE option comes with role_grants, default_roles and grants.
I am sure role_grants and grants would not solve my problem. I haven't tried default roles.
So, it would be helpful if some had faced similar situation can guide me.
Please ignore my previous message. I have been looking into the exclude syntax from when you posted a reply.
And I have been trying something like this with the exclude option.
EXCLUDE=ROLE:" LIKE 'USERNAME.%ROLE_NAME%'" and I couldn't get to exclude the role assigned to a user
Any help is highly impreciated.