Re: exp / imp question

Todd M. Helfter wrote:
>
> Could someone give me a pointer to exporting and then importing
> a user. I want to take users with their passwords from one database
> and put them in another.
>
> I have tried the exp and imp utilities, I'm not quit getting it.
>
> Todd
> --
> .------------------------------.
> | Todd M. Helfter |
> | tmh_at_purdue.edu |
> `------------------------------'
Todd,

Firstly you are prompted for your username, this will be something like: todd_at_orcl, where orcl is the database instance. Then enter your passord.

When it asks you for your array buffer size, just press enter.

Type the filename you want for your export file, EXPDAT.DMP is the default.

If you want to export the whole users schema, then press 2 which selects (2)U(sers).

Export the grants by pressing enter, yes is default.

Export table data by pressing enter, yes is default.

Compress extents means defrag the empty spaces between the data. This is a good idea, so type yes.

It should then go and export the full user's schema.

For this you will need to know their password. However if you are granted the EXP_FULL_DATABASE role by your DBA you should be able to export the whole database.

Hope this helps!

Matthew

-- 
+------------------------------------------------------+
| BT Labs Site: http://www.labs.bt.com/                |
|                                                      |
| The views expressed in this message                  |
| are those of the author and not                      |
| necessarily those of British Telecommunications plc  |
| and/or its employees.                                |
+------------------------------------------------------+