Hi.

If you don't drop the users then all synonyms and views will still be present as these aren't physical objects and so are not actually stored in a users default tablespace. They are stored in the data dictionary in the SYSTEM tablespace.

Once the import is complete they will work again so long as the correct privileges have been granted. If Tom has a view that uses a synonym to a table in John's schema, John must grant privilege to Tom before he can see the table.

If the export file contains the grants and you import with grants=y then this will be done by the import. If not you will need to do it manually.

Cheers

Tim...