Solved

oracle import database from unix to windows

Posted on 2011-03-04
4
445 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:mphillip85
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35040973
I think you answered your own question:

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

Expert Comment

by:choukssa
ID: 35041046

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
0
 
LVL 2

Accepted Solution

by:
niaz earned 500 total points
ID: 35042080
If you have only installed software on the new window server, then you have to create the database instance. If you have to create a new instance then after creating database you have should:
1. Create at least one table space where you should import the all data into.  
2. Create the user make that user tablespace a default tablespace of the schema owner who owns the schema on the Unix server.
3. Grant the new user the same privileges as it has on current Unix server. (At least CONNECT and IMP_FULL_DATABASE roles.)

Now the question is how did you export the database? Was it FULL database, Schema or just Table. Did you use exp utility or expdp. Your import command will vary based on the above options.

Please see the link blow to see the how  you can use the different options. Your best bet would be to do a FULL=Y
http://www.oracle-base.com/articles/10g/OracleDataPump10g.php
0
 

Author Comment

by:mphillip85
ID: 35044561
thanks i will try that.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question