If your table has any logical corruptions the expdp of the table might fail with ORA-155 error.
If your table has any logical corruption, first identify the rows/rowids that are corrupted and then perform the following to ignore the affected rows and take an export of the table.
SYNTAX
# expdp system/<password> DIRECTORY=my_dir DUMPFILE=expdp_satc.dmp LOGFILE=expdp_satc.log TABLES=tc.lobdata QUERY=\”WHERE rowid NOT IN \(\'<rowid’s listed in corrupt_rowid>\’\)\”
EXAMPLE
#> expdp scott/<password> directory=data_pump_dir dumpfile=test.dmp logfile=test.log tables=EMP query=\”where rowid not in \(\’AAEWBsAAGAAACewAAC\’, \’AAEWBsAAGAAACewAAF\’, \’AAEWBsAAGAAACewAAG\’\)\”
Recent Posts