Sample Header Ad - 728x90

Data pump exclude include

0 votes
0 answers
693 views
hello im learning about datapump and i trying to use include to filter which table i want to export.when i use the code below the import/export job able to run but an error occur saying that the table being skipped because the sql command not properly ended.how do i resolve this issue expdp test/asdzxc@pdb22 directory=asdzxc SCHEMAS=TEST INCLUDE=TABLE:"LIKE'REG%'" query=regions:"region_name LIKE'Americas'" dumpfile=test12.dmp Export: Release 19.0.0.0.0 - Production on Tue Oct 5 23:17:06 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "TEST"."SYS_EXPORT_SCHEMA_02": test/********@pdb22 directory=asdzxc SCHEMAS=TEST INCLUDE=TABLE:LIKE'REG%' query=regions:region_name LIKE'Americas' dumpfile=test12.dmp Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT ORA-31693: Table data object "TEST"."REGIONS" failed to load/unload and is being skipped due to error: ORA-00933: SQL command not properly ended Master table "TEST"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded ****************************************************************************** Dump file set for TEST.SYS_EXPORT_SCHEMA_02 is: C:\USERS\MARCEL\DESKTOP\DPUMP\TEST12.DMP Job "TEST"."SYS_EXPORT_SCHEMA_02" completed with 1 error(s) at Tue Oct 5 23:17:13 2021 elapsed 0 00:00:07
Asked by Silent Boots (13 rep)
Oct 5, 2021, 04:38 PM