Re: consolidate databases

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

or

export system/sys full database, import with show=y to log=..., edit the 'show file'(log) and extract the parts you need.

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 Thu Jan 30 2003 - 20:42:17 CET