Re: consolidate databases

"Svend Jensen" <svend.jensen_at_it.dk> wrote in message news:3E398019.8020208_at_it.dk...
> Not much is simple in this world.
>
> Exporting the user as privileged user (sys or system...) will give you
> most of what you want.
> Except the grants and privileges received.
> As they are owned by the one who issued them.
> You can 'build' them by looking at some nice views
> dba|user_tab_privs
> dba|user_sys_privs
> user_tab_privs_recd
> user_tab_privs_made
> obj_priviledge
> (maybe more) ...
>
> or
>
> export system/sys full database, import with show=y to log=...,
> edit the 'show file'(log) and extract the parts you need.
>

In addition to the grants and privs received, don't forget any public synonyms and role definitions (actually, these could cause conflicts when merging databases/instances by using the same name for 2 different apps).

> Anyway, its all just hard work ;-))
>
> regards
>
> /Svend Jensen
>
>
> Hans Klassen wrote:
> > Hello NG,
> >
> > i need a tip.
> > DB 8.1.7. WinXP :-)
> > I must consolidate 4 instances to 2 instances. I want to make this
> > with Exp/Imp.
> > I have the following problem:
> > i want to transfer some users and all grant, tables, indezes etc from
> > this to a already running database. In the source db, there are just 2
> > tablespaces and 23 users have theirs object in this 2 tablespaces. I
> > must transfer the users and their object to the target db, so that
> > there is no need to modify the application that accesses the data. I
> > can make a user export/import, but i need the grants too. I need the
> > simplest and correct way.
> >
> > Thanks in advance
> >
> > Hans
>
Received on Fri Jan 31 2003 - 06:51:39 CET