A User Privileges, Parameter File Contents, and Expdp and Impdp Commands for Excluded Objects
For objects that are excluded from the online DMS migration job and need
to be exported and imported manually using offline expdp
and
impdp
commands, you must know the user privileges and the contents of
the parameter file of the excluded objects.
The following tables lists the privileges to be provided to users and
the contents of the parameter file for excluded objects that need to be migrated
manually outside of the online DMS tool, and the expdp
and
theimpdp
commands that must be used for this manual migration.
User Privileges for Excluded Objects
Table A-1 lists the privileges to be provided to users when you need to manually migrate the excluded objects.
Note:
The following table lists the sample privileges to be provided to users for excluded objects. Based on your setup, provide the privileges to users for any additional schemas, if required.Table A-1 User Privileges for Excluded Objects
Product | User privileges for Excluded Objects |
---|---|
Oracle Identity Manager (OIM) |
|
Oracle Access Manager (OAM) |
|
Oracle Internet Directory (OID) |
NA |
SOA/Oracle Business Process Management (BPM) |
NA |
SOA/Oracle Business Activity Monitoring (BAM) |
A user that has been granted privileges, which are not supported by Oracle Autonomous Transaction Processing-Shared (ATP-S) database, should be revoked before migration, and equivalent privileges should be granted in the target database post migration. |
Oracle Enterprise Scheduler (ESS) |
|
Oracle Managed File Transfer (MFT) |
NA |
Oracle WebCenter Portal (WCP) |
|
Oracle WebCenter Content (WCC) |
Excluded objects get generated dynamically |
Oracle WebCenter Sites (WCS) |
NA |
Parameter File Contents for Excluded Objects
Table A-2 lists the tables that must be excluded from the online DMS migration job and
migrated outside of DMS using Data pump commands. These tables are listed in the
parameter file (parfile
), which is passed as a parameter to the
expdp
command.
The INCLUDE
parameter specifies the tables to be included in the
expdp
command.
Note:
The following table provides sample tables listed in the parameter file. Based on your setup, provide any additional tables, if required.Table A-2 Parameter File Contents for Excluded Objects
Product/Component | Parameter File Contents |
---|---|
Oracle Identity Manager (OIM) |
|
Oracle Access Manager (OAM) |
|
Oracle Internet Directory (OID) |
NA |
SOA/Oracle Business Process Management (BPM) |
|
SOA/Oracle Business Activity Monitoring (BAM) |
|
Oracle Enterprise Scheduler (ESS) |
If the domain contains SOA, SOA excluded tables must also be included |
Oracle Managed File Transfer (MFT) |
|
Oracle WebCenter Portal (WCP) |
|
Oracle WebCenter Content (WCC) |
NA |
Oracle WebCenter Sites (WCS) |
NA |
Metadata Services (MDS) |
|
Expdp and Impdp Commands for Excluded Objects
Table A-3 lists the expdp
and impdp
commands to manually
migrate the excluded objects listed in Table A-2
Note:
The following table lists the sampleexpdp
and impdp
commands to manually
migrate the excluded objects. For any additional schemas in your setup, update
the commands, if required.
Table A-3 Expdp and Impdp Commands for Excluded Objects
Product/Component | Expdp and Impdp Commands |
---|---|
Oracle Identity Manager (OIM) |
|
Oracle Access Manager (OAM) |
|
Oracle Internet Directory (OID) |
NA |
SOA/Oracle Business Process Management (BPM) |
|
SOA/Oracle Business Activity Monitoring (BAM) |
|
Oracle Enterprise Scheduler (ESS) |
For PROCOBJ objects, use the following
expdp
command
For PROCOBJ objects, use the following
impdp
command
|
Oracle Managed File Transfer (MFT) |
|
Oracle WebCenter Portal (WCP) |
|
Oracle WebCenter Content (WCC) |
NA |
Oracle WebCenter Sites (WCS) |
NA |
Metadata Services (MDS) |
|