Скачать с ютуб How to Exclude Schemas and Tables using Export and Import. /* Step By Step */ в хорошем качестве

How to Exclude Schemas and Tables using Export and Import. /* Step By Step */

Today I am showing you 1. How to perform Export and Import with Exclude Schemas and Tables in Oracle Datapump utility. When we take a Export Full database Backup but I don’t take a backup of Scott and System Schemas. That time we can use Exclude command. We can Export Scott Schema but exclude EMP , DEPT Tables. If the expdp exclude parameter is used directly from the command line (and  not in a parameter file (parfile)), the special characters (quote marks) in the exclude clause may need to be escaped with  backslash (\) character . Because of this, it is recommended that you always use a parameter file (parfile). In Windows we used round bracket ( ) in IN clouse. But In Linux, we used { } bracket. Exclude Schema: expdp system/admin directory=mydump FULL=Y dumpfile=full.dmp exclude=schema:\"=\'SCOTT\'\“ expdp system/admin directory=mydump FULL=Y dumpfile=full.dmp exclude=schema:\”In{\'SCOTT\‘,\’SYSTEM\’}\“ Exclude Tables: expdp system/admin directory=mydump schemas='SCOTT' dumpfile=scott.dmp exclude=table:\"=\'EMP\'\“ OR expdp system/admin directory=mydump dumpfile=scott.dmp schemas=‘SCOTT’ exclude=:\"IN {\’EMP\',\’ DEPT\‘}\“ It is very easy to understand.