Re: Full Ex/Im-port to New Instance, NT

Yassir,

---You said---
>You have to Create all the Database Users As Well as Synonyms, Roles and
>Grants of all the database users, otherwise your import will not import all
>the exported data "user Objects"..

    If you have to create all these things than the purpose of FULL EXPORT/IMPORT is totally defeated.

    Believe me Oracle Full import will do it all for you. I think you never knew about it. Try it next time, let me know if you found otherwise, as I myself would like to know. I have done it myself a dozen of times.

Jurji, thanks for explaining it and also clarifying about the PL/SQL stored procedures which may be INVALID due the the order in which they get created at the import time. All such procedures will be recomplied at the time they are executed, so this should not be an issue. If someone thinks it is a problem then you can use Oracle Provided COMPILE_ALL utility could be used.

Yassir, hope this clarifies your misunderstanding.

hope this helps out,

Manoj Jain
Certified Oracle Professional - OCP DBA Chauncey Certified Oracle7 DBA

In article <361d1602.5989516_at_news.siol.net>,   jmodic_at_src.si (Jurij Modic) wrote:
> On Thu, 8 Oct 1998 11:14:53 +0100, "Yassir Khogaly"
> <yassir_at_khogaly.freeserve.co.uk> wrote:
>
> >Hi...
> >
> >That is Not all my dear ...!
> >
> >You have to Create all the Database Users As Well as Synonyms, Roles and
> >Grants of all the database users, otherwise your import will not import all
> >the exported data "user Objects"..
>
> That is simply not true. Full database export/import will take care
> for all the things you mention. It might be the case that some PL/SQL
> stored objects will be marked as unvalid but they will eventualy
> recompile the first time they will be called. Hovewer, users,
> synonyms, roles etc will be imported just fine.
>
> I belive the procedure proposed by Manoj Jain covers just about
> everything needed to replicate the existing instance.

>
> >Best Regards
> >
> >B.Sc. Yassir Khogaly
> >Senior Oracle DBA - Consultant
> >United Kingdom
>
> Regards,
> --
> Jurij Modic <jmodic_at_src.si>
> Certified Oracle7 DBA (OCP)
> ================================================
> The above opinions are mine and do not represent
> any official standpoints of my employer
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 08 1998 - 21:24:11 CDT