Re: Importing several users

On Tue, 21 Mar 2000 01:40:06 -0800, Mario Bucsics <mario.bucsicsNOmaSPAM_at_siemens.at.invalid> wrote:

>Hi !
>
>Just use the system or sys user to import some users objects.
>The imp program does not create any objects for other users in
>the system tablespace except those user objects which have
>already been created in the system tablespace in the source
>database. But this should be avoided.

Thanks. It's true.
I must have done something wrong the first time I tried, because imp created everything on the system user and I had to reinstall, but this time it worked. Imp created the objects under the correct users.

There is only a slip. I find some errors corresponding to view creation in the log file like this:
IMP-00041: Warning: object created with compilation warnings

I don't know what's wrong with this views at import time, because, after import, I can compile them (with alter view ... compile) with no problem at all.
Is it possible that this views fail because of calls to functions in the select list or where clause?

--
Julio César Glez Suarez
Xixón, Asturies, Spain
jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)