Re: Q: Exporting with user mode and dopping the users

levy wrote:
>
> I want to export all the objects owned by some users
> and drop(delete) the objects and the users.
>
> Later if the objects must be restored , can I restore all
> as same as before the exporting? If I can, how?
>
> I think, the user information should be exported before
> the exporting of data objects, and imported before
> the importing of data objects.
> But I don't know how to do for this.
>
> Thanks in advand for your kind answers.

Do an export with owner=your_user_name , with this you get all objects of the user
in your exp-file.
You can now drop the user.
In cases where you need to import this user, you have to create the user in the
DB befor you can do the import.
Importend things to remember:
- The imp tries to create the table, index, clusers, etc. in the same tablespace
  as they have been prior export with the same storage parameters. - See the Oracle Utilities Book , Chapter Export Modes what objects are   exported in which mode

HtH
eugen Received on Fri Jul 03 1998 - 05:53:19 CDT