If you imported a dump file containing the same tables for this user previously, you must clear all tables before a new import. Delete can be done with the following statement in SQL*Plus:
truncate table <tablename>;
You can also drop the whole user by using the cascade option to erase all the user's objects:
drop user Smart Instrumentation cascade;