Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Copy everything from one user to another

Copy everything from one user to another

From: <yong321_at_yahoo.com>
Date: Wed, 28 Apr 1999 15:01:23 GMT
Message-ID: <7g77s2$7aa$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US