Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import database question
Dave Hau <davehau_nospam_123_at_nospam_netscape.net> wrote:
>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
>
>
To do this you need to be have DBA role assigned to the user running the import.
>
>
>
>>
>> Moreover, Is there any extra procedure before import dmp file??
>>
>> thx
>>
>>
Received on Tue Jul 15 2003 - 11:08:17 CDT