Re: Exporting problem

Thanks Hans. Your tips really helped.

John
"Hans de Ruiter" <hans.ruiter-de_at_siemens.nl> wrote in message news:a7eude$r3v_at_thor.siemens.nl...
> John;
>
> (Note: I've said alert-log didn't I? I ment the creation-db-log...thought
of
> the one wrote the other)
> It's normally not done to rerun these scripts again, there are some
possible
> reprecussions. Suppose a script does the following; dropping an table
> belonging to user x (Normal procedure while creating objects) and creates
> it, and than in script 2 drops the creating any table clause of user x.
> Rerunning script 1 again would cause an error telling user x can't create
> any tables. Since catproc calls quit a huge number of scripts it's
> impossible to oversee it's impact. Consider an full -export under sys.
> Since the export wouldn't take any sys and system objects, you wouldn't
run
> into any problems. (If you tried to export the user sys: thats also not
> done) Recreating the database will cost you much less time.
>
> Hans
>
> "J. Harris" <John.Harris_at_nurs.utah.edu> wrote in message
> news:a7dok8$q2u$1_at_coward.ks.cc.utah.edu...
> > What kind of repercussions are there for re-running those scripts?
> >
> > Thanks,
> >
> > John
>
>
>
Received on Fri Mar 22 2002 - 12:15:09 CET