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

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 08 Oct 1998 20:56:57 GMT
Message-ID: <361d1602.5989516@news.siol.net>

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 Received on Thu Oct 08 1998 - 15:56:57 CDT