Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Anyway I can move a user OR schema from a DB to another DB?

Re: Anyway I can move a user OR schema from a DB to another DB?

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Fri, 22 Jun 2001 17:29:25 -0700
Message-ID: <3B33E2E5.191D3D14@attws.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US