Copy everything from one user to another

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 Received on Wed Apr 28 1999 - 10:01:23 CDT