Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you move a schema from one server to another?
I have tried the EMP/IMP but on IMP of the CLOB table it errors out.
Any suggestions?
Thanks,
Kev
On Tue, 19 Jun 2001 19:29:54 GMT, "EB" <EB_at_nOsPaM.com> wrote:
>Use the import/export utility:
>
>exp file=file.dmp owner=old_schema_owner userid=system/password log=export
>
>imp file=file.dmp log=import userid=system/password
>fromuser=old_schema_owner touser=new_schema_owner
>
>
>
>"Kev" <java2e_at_yahoo.com> wrote in message
>news:m8juitcd7ln8rc5ubbtbq7gkv05ooqi8fq_at_4ax.com...
>> Hello All,
>>
>> I need to be able to move a schema/user (tables, indexes, triggers,
>> sp, etc..) from one server to another. What is the best way to do
>> this?
>>
>>
>> Thanks,
>>
>> Kev
>
Received on Tue Jun 19 2001 - 20:31:43 CDT