Re: Full Oracle Import

Hi Yat-Fan,
First question: Yes the user definitions are exported in a full database export, however in a full database export ONLY. User export doesn't export them.
Second question: You should specify ignore=Y on the commandline or answer yes to ignore errors due to object existence. As there is always two statements in the export (CREATE user and ALTER user) the first will fail, however the second will not. This statement will reset the password, and the default and temporary tablespace specifications.

Hth,

Sybrand Bakker, Oracle DBA

Yat-Fan wrote:

> Hi Oracle Experts,
>
> If I do a full Oracle (v7.3) database import from an
> export dump, am I right to say that user definitions
> would also be imported?
>
> But when there are users already created manually,
> what would the importing action do to the existing
> ones? There can be users of the same name also.
>
> Many Thanks.
>
> Rgds.,
> fan.
> ps. The best is if one copy of the answer can be forwarded
> to me at fan_at_alumni.ust.hk.
Received on Sun Sep 06 1998 - 07:39:45 CDT