Re: common import warning question

When doing a full import, the message about "created by ..." is just an FYI. Import will not do the full import unless the import user has DBA priv anyway.

I'd have to double check the code to see if under fromuser= mode, if it makes any difference (I don't think so, but don't quote me on that).

On full import (full=y) items should be created in under the same user they were under on the exported database, including items belonging to "sys".

Brian McCarthy

Doug Cowles wrote:
>
> Perhaps it's just a friendly way of letting me know I'm dealing with a
> "sys" export
> just in case I didn't know? In any case, my understanding is that
> objects owned by
> sys come in on a sys full import, and not on a system. Is that accurate?
> What sort
> of trouble could I be in by using sys exp/sys imp rather than system, and
> under what circumstances would I want to do sys/sys?
>
> - Dc.
>
> Doug Cowles wrote:
>
> > I get this a lot since I am somewhat confused about doing full imports
> > or exports as sys or system.
> >
> > When doing an import - >
> > - Warning - objects were exported by sys, not by you...
> > Why the warning? What could happen?
> >
> > Could anyone help me fill out this little matrix?
> >
> > Export done as Import Done as Ramifications?
> > sys sys
> > sys system
> > system sys
> > system system
Received on Fri Jan 21 2000 - 06:39:28 CST