Parameters FROMUSER and TOUSER in Oracle IMP (import)
Posted on 2004-04-14
I'm trying to import a copy (DMP file) of the Millennium schema from the A0218174 into the Oracle database on my Laptop, but I'm confused about how to use the TOUSER parameter.
I'm looking at the documentation for the Oracle command line "imp" import utility
and am following most of the information on how to set the parameters, but I'm confused about how to bring in the Millennium schema properly.
It looks like I'm supposed to use DOS command:
(where I'm defining some parameters in the parameters.dat file)
then give it USERID: "sys as sysdba" when it asks for it,
and then the password (which I won't repeat here).
and the filename ("EXPDAT1.DMP" in my case)
-- I assume that I have to run the command line "imp" while the DOS window's default directory is set to the directory containing that DMP file.
I assume that I should give it the parameter (this is in the parameters.dat file):
(Actually, I read on the Internet that the syntax for this is supposed to be like:
-- where "millennium" is the name of the schema from which it was exported in the Oracle database at our client's site in Texas, and to which it should be imported in the Oracle database on my laptop. Millennium is also the schema owner's name.
Does using the parameter "FROMUSER=MILLENNIUM" assume that the user ID used to export the Millennium schema was "millennium"? What if the user who exported the .DMP file (which I assume contains only the millennium schema) was "system" or "sys" or some other user name?
Does it matter what user ID the person who exported the file used?
In my parameters file, I also had the line "TOUSER(MILLENNIUM)"
but I got an error saying that user did not exist.
-- Do I first have to create a user named "millennium" in the instance of Oracle on my laptop?