Solved

oracle import database from unix to windows

Posted on 2011-03-04
4
448 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

717 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