Re: import database question

From: Dave Hau <davehau_nospam_123_at_nospam_netscape.net>
Date: Tue, 15 Jul 2003 15:49:10 GMT
Message-ID: <3F142273.6050106@nospam_netscape.net>

myhome wrote:
> I have a dmp file for my database SID=test. I have export the database for
> user "owner". So do I need to create "test" database and user "owner" before
> I import this dmp file??

You can import the dmp file into any user's schema on any database. Just do:

imp <someuser>/<password> file=dumpfile.dmp fromuser=owner touser=someuser rows=y tables="(*)"

Cheers,
Dave

>
> Moreover, Is there any extra procedure before import dmp file??
>
> thx
>
>
Received on Tue Jul 15 2003 - 10:49:10 CDT