This content has been marked as final. Show 2 replies
expdp and impdp operations should not be executed as SYS - try SYSTEM account instead. See first Note section here - http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm#sthref243
Pl post the complete expdp and impdp commands used, along with a description of the table for which you encounter this error.
Thanks for pointing that out Srini. Will keep that in mind. Now situation has changed and will be doing expdp for complete tablespace, so don't need to truncate but will be dropping table space.