Re: How do you move a schema from one server to another?

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 - 14:29:54 CDT