Import existing DMP in Oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Import existing DMP in Oracle 9i

Hybrid View

  1. #1
    Join Date
    Jan 2005
    Location
    RIzal, Philippines
    Posts
    1

    Import existing DMP in Oracle 9i

    Hi!
    I'm new here and also in using Oracle 9i.
    I have a problem that I want to ask some favor to whoever would want to answer my question?
    Before, we had an Oracle server (my boss installed this one!)... A few weeks ago we formatted the Oracle Server, although we first save the dmp file in a safe location. Now I had already installed the OS (Windows 2000 Server, with Active Directory and DNS running). My problem now is that, when we imported the dmp file using JOBS, it always display a failed message "VNI-22015: The node preferred credentials for the target node are either invalid or do not have sufficient privileges to complete the operation. On Windows platforms, the node credentials specified for the windows target should have the "LOG ON AS A BATCH JOB" privilege." Can someone please help/teach me how to import correctly the DMP. Also, what type (roles, ) will I add to the user name that i will use to import this. I do not how to use the command mode so maybe you can teach me in different ways, although I will very greatly appreciate if someone will also teach me how to use it.

    Thanks in advance.
    You can also e-mail me at jjx34ever@yahoo.com

    God bless to all
    Last edited by jjx34ever; 01-09-2005 at 09:44 PM.

  2. #2
    Join Date
    Oct 2006
    Posts
    175
    Before you do the import, run the catalog.sql or catexp.sql scripts located at %ORACLE_HOME%\rdbms\admin, which will install two most essential roles for import and export i.e., IMP_FULL_DATABASE and EXP_FULL_DATABASE. And next, grant IMP_FULL_DATABASE to the user doing the import. And finally run the IMP tool in console to do the import. Am I clear enough ? ;P

    always,
    gtcol

  3. #3
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Mention the steps you did to get your database up after you formatted your server( Assuming that you have created a database after installing Windoze and Oracle softwares).
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width