Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Anyway I can move a user OR schema from a DB to another DB?
Huoy-Jii Khoo wrote:
> I was wondering if I could move a user or schema which contain tables, data,
> form, reports, etc from one DB instance to another DB instance?
>
> The all tables, data, forms, reports belongs to that schema OR user.
>
> Thanks.
> khoo
Use EXPORT (exp) followed by IMPORT (imp).
Daniel A. Morgan Received on Fri Jun 22 2001 - 19:29:25 CDT