Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to backup users and roles?
Please, show me how to do it. I couldn't understand how to backup without data and why to use log. Sorry, I am not a DBA and my knowledge of IMP/EXP is very basic.
What about the passwords?
On Thu, 24 Aug 2000 08:29:45 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
>Apparently you are exporting in user mode.
>Roles are exported in full database mode.
>You could easily run a full database export without data, run an
>import with show=y full=y log=<any filename> and edit <any filename>
>to isolate the roles.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
Received on Thu Aug 24 2000 - 09:24:26 CDT