I've received a database from a client in the .exp format and I need to import it but I'm only familiar with .dmp files that I've created. I have tried the imp utility but it asks me for information about the exporting database that I don't have. Do you have any ideas on how to import this db? Do I need to go back to the client to find out more information about the export?
Any thoughts would be great!
01-30-2002, 04:50 PM
What kind of information is it asking for?
The .exp may just be how that administrator names the export files. That's how I name mine and the usually import just fine.
01-30-2002, 04:53 PM
It asks me for the FromUser but I don't know the specifics about their users. I figured the .exp may be just because that's the name the administrator choose but I wasn't sure. I looked through the file and I think I found the username of the schema owner so I guess I'll need to create that user in order to import????
01-30-2002, 04:57 PM
If you do know the username that was exported, you can import into any user you want by using either the FROMUSER= [old username] TOUSER = [your new username] or the FULL= Y parameters
01-30-2002, 04:59 PM
can I use the FULL=Y is I don't know if they've done a full export of user export?
01-30-2002, 05:00 PM
I'm pretty sure the FULL= Y just means to import the entire export file. So if they only did a user export, you'll only get that user.
01-30-2002, 05:22 PM
I created the user and the data is in!! Thanks for your help and tips.