How to Import the whole database into a new database?
I have a newly installed Oracle Database(it have nothing), and i have an old one on another machine...what i want is:
- to perform a import operation from the older one into the new one.
I already heve performed the dump of the database i want to import, but, how to import it into another empty database, and i mean really empty.
does it have to be a clone of the older one?(i mean the database structure.)if yes, how can i export thewhole database structure of a database and import it on another by subscribing the old structure with the new one?
I performed my dump by typing at C prompt:
so i´ve answered every question with "yes", except by the first question.
Both are Oracle9i version.