Solved

How do I imort dmp file into oracle 11G

Posted on 2012-04-10
4
1,005 Views
Last Modified: 2012-04-20
Hi,
I just installed oracle11g, and I created a user ajoo_user password abcd. I have a dmp file which I need to import. I found this command

impdp <username>/<password> directory=my_dir dumpfile=exp_tab.dmp logfile=imp_tab

What user name password is it?

Thanks
Ajoo
0
Comment
Question by:Ajoo71
[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
 

Author Comment

by:Ajoo71
ID: 37830712
Our documentation mentions to use this command where admin/admin123  is the user name and password of machien.  I am trying this on my local windows machine. what user name password I should mention, my windows7 username passwor?

impdp admin/admin123 dumpfile=expdp_ORA18B_POL_06JAN2012.dmp logfile=impdp_02212012.log directory=dp_dir SCHEMAS=POLAR remap_Schema=POLAR :ajoo_user transform=segment_attributes:n
0
 
LVL 12

Expert Comment

by:Praveen Kumar Chandrashekatr
ID: 37830932
you have give the username you has the rights/privileges for import/export

check this doc for more info on import/export.

http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php
0
 
LVL 4

Accepted Solution

by:
ytarkan earned 500 total points
ID: 37831360
it is oracle user and pass. If the user you mention (ajoo_user) is the user you have created in oracle then command should be like :

impdp ajoo_user/abcd directory=my_dir dumpfile=exp_tab.dmp logfile=imp_tab

may be better to remind that "my_dir" is not a windows directory but an oracle diretory created in oracle (for example create directory my_dir as 'c:\backups\'; then GRANT READ,WRITE on directory mydir to ajoo_user;)
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
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…
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 set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

632 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