TABLE_EXPORT_OBJECTS, How and Why
TABLE_EXPORT_OBJECTS To INCLUDE or EXCLUDE specific object type in exporting or importing tables, you should know what name of object type should be used. To… Read More »TABLE_EXPORT_OBJECTS, How and Why
EXCLUDE
SCHEMA_EXPORT_OBJECTS, How and Why
SCHEMA_EXPORT_OBJECTS To INCLUDE or EXCLUDE specific object type in exporting or importing schemas, you should know what name of object type should be used. To… Read More »SCHEMA_EXPORT_OBJECTS, How and Why
DATABASE_EXPORT_OBJECTS, How and Why
DATABASE_EXPORT_OBJECTS To INCLUDE or EXCLUDE specific object type in exporting or importing the full database, you should know what name of object type should be… Read More »DATABASE_EXPORT_OBJECTS, How and Why
How to Resolve ORA-39071: Value for EXCLUDE is badly formed.
ORA-39071 Saw some errors including ORA-39071 and ORA-39001 when export some tables form the database. [oracle@test ~]$ expdp system/password@orclpdb dumpfile=test.dmp logfile=test.log schemas=hr exclude=table:"in ('EMPLOYEES', 'DEPARTMENTS')"… Read More »How to Resolve ORA-39071: Value for EXCLUDE is badly formed.
How to Resolve bash: syntax error near unexpected token `('
bash: syntax error near unexpected token ( Tried to export some data by data pump, but it failed with bash: syntax error near unexpected token… Read More »How to Resolve bash: syntax error near unexpected token `('