Re: Copy everything from one user to another

Yong,

You're on the right track with EXP/IMP. Try the FROMUSER=PRODUCTION and TOUSER=TEMP parameters on your import.

Cheers,
Rich

In article <7g77s2$7aa$1_at_nnrp1.dejanews.com>,   yong321_at_yahoo.com wrote:
> Our dabatase has a user PRODUCTION and I created another TEMP, both having
> DBA role. Now I want to create everything PRODUCTION has for TEMP. I tried
> EXP73 at the command line trying to export everything from PRODUCTION. But
> when I run IMP73 and specify TEMP, I see on screen it says ALTER SESSION SET
> CURRENT_SCHEMA="PRODUCTION" then it always says Failed because the object
> already exists. How can I achieve what I want? Is using Import and Export the
> right way at all? Thanks a lot.
>
> Yong
> Email:yong321_at_yahoo.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

--

Rich Goldkamp, Consultant, OCP		RJGoldka_at_dcss.com
Digital Consulting & Software Services	(504) 523-5005 x2736

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own