Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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