Re: exp/imp question
From: John Flack <RHUZ94A_at_prodigy.com>
Date: 1996/04/30
Message-ID: <4m68dp$1gni_at_useneta1.news.prodigy.com>#1/1
Date: 1996/04/30
Message-ID: <4m68dp$1gni_at_useneta1.news.prodigy.com>#1/1
>I want to export, drop, recreate, and import a user. The catch is I
>want to import all the privileges the user originally had too. Is
>there an easy way to do this?
What are you really trying to do? If you just want to recreate the
user's objects, don't drop the user, just drop the objects. It is easy
to use SQL to generate SQL for dropping all of a user's objects (though I
wish Oracle would give us a command for this). Just select 'drop
'||object_type||' '||object_name
||';' from all_objects where owner = 'username';
Received on Tue Apr 30 1996 - 00:00:00 CEST