asked on

oracle import database from unix to windows

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?

Thank You.

slightwv (䄆 Netminder)

I think you answered your own question:

Pre-create the database, tablespaces and users. Then import the file.

choukssa

You will have to create tablespace and datafiles. It will look some thing like this

CREATE TABLESPACE MYDATA_TBS  DATAFILE '/data/oradata/mydb/mydata.dbf' SIZE 10240K AUTOEXTEND ON  NEXT 8K;

Open in new window

You can also generate it from your source DB

select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces tb;

Open in new window

Once you have done this then datadump can be imported using imp or impdp (depends on how you exported it).

--choukssa

ASKER CERTIFIED SOLUTION

niaz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mphillip85

ASKER

thanks i will try that.