ORA-14460: Only one COMPRESS or NOCOMPRESS clause may be specified

ORA-14460: only one COMPRESSor NOCOMPRESS clause may be specified


Just use "transform=segment_attributes:n" parameter in import

impdp user/pass@ directory=dump_loc dumpfile=users_tb.dmp logfile=users_tb.log tables=dept -->>Error

ORA-14460: only one COMPRESSor NOCOMPRESS clause may be specified.........

Two solutions are there -

Solution -1
impdp user/pass@ directory=dump_loc dumpfile=users_tb.dmp logfile=users_tb.log tables=dept transform=segment_attributes:n


Solution -2
Just create a table prior to import, Get the script from above dump with use parameter "sqlfile" or the db where we have exported that table then

impdp user/pass@ directory=dump_loc dumpfile=users_tb.dmp logfile=users_tb.log tables=dept table_exists_action=append



Thanks
DB Tech Solutions