Re: Export, Create, Import

"Dave" <JustShutUp_at_azwhole.com> wrote in message news:<bi0ian$ede9$1_at_netnews.upenn.edu>...
> In my database, I have roughly 80 users. How do export each user, create
> the users accounts in the destination database, and import them into the new
> database without manually doing each one? Does anyone have any SQL scripts
> or are there any tools availble that do this?
>
> I am trying to import all the data from a database to a new database and
> this is the first error I caught (user does not exist).
>
> Thanks in advance.
>
>
> Dave

A full database export will contain the create user statements. You can easily 'export' the create user statements from dba_users if you know that identified by values '<hexadecimal password string from password column in dba_users' will work.

Sybrand Bakker
Senior Oracle DBA Received on Thu Aug 21 2003 - 12:52:57 CEST