The user doing the import must have the privilege -- usually DBA

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "rajesh" <oracledba-ezmlmshield-x52083357.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, May 31, 2007 8:59 AM
Subject: RE: export import question


> Try
>
> Fromuser= old_username touser=new_username
>
>
> Cheers,
> Rajesh Kumar
>
>
> -----Original Message-----
> From: Praveer Misra
> [mailto:oracledba-ezmlmshield-x90743356.[Email address protected]
> Sent: 31 May 2007 13:58
> To: LazyDBA Discussion
> Subject: Re: export import question
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Try the remap_schema=original,new option in datapump.
>
> Sincerely,
>
> Praveer Misra
> Oracle DBA
> Cheetahmail, an Experian Company
>
>
> On May 31, 2007, at 8:53 AM, Schleicher Jeremy D. wrote:
>
>> Can you export data from one owner and import it that same data to a
>> new owner?
>>
>>
>>
>> Jeremy Schleicher
>>
>> ERP Database Administrator
>>
>> Florida State University
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
>
>> a dba job: http://jobs.lazydba.com To Subscribe :
>> http://www.LazyDBA.com To unsubscribe:
>> http://www.lazydba.com/unsubscribe.html
>>
>>
>>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (Darwin)
>
> iD8DBQFGXsZabSFafjNKjwIRAlK9AJ4+s+2Nm29BO2aR02H6ql950CZKIQCfSujf
> TaePS3/DLaqI3Z8kj5DsEgQ=
> =5rmP
> -----END PGP SIGNATURE-----
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>

Oracle LazyDBA home page