Re: EXPORT/IMPORT - Restoring Users' Schemas

If the export dmp was taken as full=y, then the create user statements for all existing users should be present in the file and should be imported via the import with full=y.

However if you are doing a fromuser import then you will need to extract the create user statements from the full export file (which can be a rows=n type) place a ';' at the end of each line and run it as an sql script via sqlplus. I would suggest an awk to add the semi-colon, and you cannot use vi to edit the dmp file (textedit or pfe32 will work).

In article <36A90785.5A87_at_nospam.ln.ssw.abbott.com>, graham.thornton_at_nospam.ln.ssw.abbott.com wrote:
>Hello,
>
>I need to restore about 1200 users from a EXPORT dump file -
>complete with schema, tables, indexes etc.

Snipped text here
>
>Is there a way to force IMPORT to create the user on-the-fly, or
>do I need to create a separate script to create all of my users
>before-hand? If so, is there a way to restore their old passwords?
>
>Thanks for any thoughts.
>
>Graham.
Received on Sat Jan 23 1999 - 14:20:44 CST