oracle import database from unix to windows
Posted on 2011-03-04
i have a 11g database on a unix system and i want to import one of the database's from it to a windows server that has 11g on it.
i have been told i have to create the tablespaces, roles and database name in order to import the database.
what i remember last when i did this i just pointed to the exported database file(s) and then chose the appropriate credentials and imported using the gui interface. I did not use the import database option and I followed any prompts it had and I was fine.
so the question is.. once i have the exported database from the unix server copied to the windows server, what is the easiest way to import it once i have the file(s) into the 11g oracle windows sever 2008?