Hi Guys,

I have taken FULL export of D.B with COMPRESS=Y option. Now I want to import it back in the same Database.

Main purpose of full export/import is to remove fragmentation and reorganize the database.

Do I have to first drop all the users with cascade to make the database empty keeping only SYS and SYSTEM users?

Do I have to do import with IGNORE=Y.

Pl. help to clarify.

Thanks in Adv.