Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    57

    Unanswered: implementing local database from an Oracle dump (DMP) file

    hi folks,

    here is the deal, i have this Oracle 8i dump (DMP) file and i want create a database on my machine (a local DB for my development purposes) from it. how do i do that?

    thanks all.

    btw, i am on a WinXP machine, if that makes any difference.
    Last edited by my_lou; 10-27-03 at 10:56.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: implementing local database from an Oracle dump (DMP) file

    Originally posted by my_lou
    hi folks,

    here is the deal, i have this Oracle 8i dump (DMP) file and i want create a database on my machine (a local DB for my development purposes) from it. how do i do that?

    thanks all.

    btw, i am on a WinXP machine, if that makes any difference.
    You do NOT.

    To import a *DMP file a functioning database is REQUIRED to exist
    prior to issuing the "imp" command. Once you have an empty DB,
    then import your file.

  3. #3
    Join Date
    Oct 2003
    Posts
    57
    ohh, well, i am an Oracle newbe, sry if that looked like a dumb question to you.
    so i guess i have to set up a DB on my machine? how do i do that (give me details please)?

    btw, this DB will be on my local machine for my use only, i.e. i will be the only user. it's basically a test database for the project i am working on.
    Last edited by my_lou; 10-27-03 at 12:00.

  4. #4
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    Set up DB

    Do you have the disks from Oracle or a network setup for Oracle? Must have one or the other. Feed the disks into the cdrom and follow the screens. One of the questions during setup of the Database is "Do you want Oracle to create a DB for you?" answer yes and have Oracle create the Database for you.
    Michellea Southern-David

Posting Permissions

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