1. Does using the parameter "FROMUSER=MILLENNIUM" assume that the user ID used to export the Millennium schema was "millennium"?
No, it means MILLENNIUM is the owner of the object
2. 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?
No issue. SYS and SYSTEM have right to export database at any level (database, user or table). If your MILLENNIUM has export right you can use it to export.
3. Does it matter what user ID the person who exported the file used ?
See above. Only one issue is if you export for example a table that owned by other schema you have to specify:
TABLES=<schema>.<tablename
4. Do I first have to create a user named "millennium" in the instance of Oracle on my laptop?
Yes. It's required to use "TOUSER" option even you specify the millennium for both FROMUSER and TOUSER.
If you import a full database you may not need to pre-create the user
Hope this helps
Main Topics
Browse All Topics





by: seazodiacPosted on 2004-04-14 at 10:21:25ID: 10825570
-- Do I first have to create a user named "millennium" in the instance of Oracle on my laptop?
Yes, of course