-
Hi,
i got an export.dmp file from an outside source. this file is sitting in my machine.
On my local machine, i have a user. How do i do an export and import into this user on my machine?
thanks
-
Thanx
Sam
Life is a journey, not a destination!
-
do and import with show=y option to find out the tablespace and info about that dump file.
Create the user
import the dump something like this
imp system/manager file=files.dmp log=log.log fromuser=joe touser=joe
I hope this help
-
Mike,
i did as u had told.
Export file created by EXPORT:V07.03.04 via conventional path
Warning: the objects were exported by WOLF, not by you
. importing WOLF's objects into NZM
.......
I created two users WOLF and NZM
when i run import i get this error
C:\>imp80 system/manager file=h:\user\suresh\exp01902.dmp fromuser=WOLF touser=W
OLF ignore=Y
Import: Release 8.0.4.0.0 - Production on Mon Jan 14 16:14:46 2002
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Connected to: Oracle8 Personal Edition Release 8.0.4.0.0 - Production
PL/SQL Release 8.0.4.0.0 - Production
Export file created by EXPORT:V08.00.04 via conventional path
Warning: the objects were exported by SCOTT, not by you
IMP-00034: Warning: FromUser "WOLF" not found in export file
how to proceed ?
-
Don't worry about who exported them. I get that message as well if another DBA does the export or if I use one of his files.
You need to create the username that is in that dump file not the user that did the export.
MH
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|