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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: export as user A in tablespace B, import as user C in tablespace

Re: export as user A in tablespace B, import as user C in tablespace

From: Dries Verachtert <dries_at_ulyssis.org>
Date: Thu, 2 Nov 2000 11:34:28 +0100 (CET)
Message-Id: <10668.120935@fatcity.com>


Hello,

The user has no tables. Ik did a 'drop user winemirror cascade; create user...' before i tryed the import... There are tables with the same name in the database, but they are owned by another user 'wine'. So.. as far as i know, oracle makes a difference between the table wine.tblactions and winemirror.tblactions?

Thanks in advance for any help,
Dries Verachtert

On Thu, 2 Nov 2000, K Gopalakrishnan wrote:

> Date: Thu, 02 Nov 2000 01:45:25 -0800
> From: K Gopalakrishnan <kaygopal_at_yahoo.com>
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: export as user A in tablespace B,
> import as user C in tablespace D:
>
> Hi !!
>
> Looks like there are some tables already exist in the
> target user's schema. If it is for testing (Only) you
> simply drop and recreate the user and run the import
> with ignore=y option.
>
>
>
> =====
> Warm Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
> __________________________________________________
> Do You Yahoo!?
> >From homework help to love advice, Yahoo! Experts has your answer.
> http://experts.yahoo.com/
>

-- 
----
Dries Verachtert, Skotty_at_IRC, dries_at_ulyssis.org
"You're one of those condescending Unix computer users!"
"Here's a nickel, kid.  Get yourself a better computer" - Dilbert.
Received on Thu Nov 02 2000 - 04:34:28 CST

Original text of this message

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