exclude parameter in Oracle EXP Datapump

expdp dumpfile=<file_name>.dmp exclude=TABLE:\"IN \(\'<table_name1>\',\'<table_name2>\',\'<table_name3>\'\)\"   schemas=<user_name>

Note :- If original Export used INDEXES=n, then Data Pump uses the EXCLUDE=INDEX parameter. If original Export used INDEXES=y, then Data Pump uses the INCLUDE=INDEX parameter".


Popular posts from this blog

finding fragmentation at table level and tablespace level in Oracle and steps to remove them

ORA-01153: an incompatible media recovery is active standby database oracle

ORA-16191: Primary log shipping client not logged on standby