restoration of oracle database

Can i restore different dumps(databases) on开发者_JS百科 a single database created through the database configuration assistant in oracle 10g. i mean to say that the previous tablespaces must be overwritten by the new one thus saving the time to create new tablespace everytime we restore a dump file.

---

yes it is possile by creating a new user.the new user will act as a new schema and can exist with the previously imported data without overwriting it. how ever if i want to import different data using the same user then the previously stored data must be dropped along with the user first,the agin the user must be created; Command to do this is

DROP USER CASCADE; This will drop the previously stored data without deleting the tablespaces thus saving time to create new tablespaces.