• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1014
  • Last Modified:

How do I imort dmp file into oracle 11G

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
Ajoo71
Asked:
Ajoo71
1 Solution
 
Ajoo71Author Commented:
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
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
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
 
ytarkanCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now