exp file=<file_name> log=<exp_logfile> rows=n grants=n (
userid=owner/password OR enter the username and password when prompted)
imp file=<file_name> log=<imp_logfile> fromuser=<exp_owner>
touser=<imp_owner> (userid=<user_with_DBA>/passowrd)

Regards
Amin Adatia ([Email address protected]
KnowTech Solutions Inc. (www.knowtech.ca)
(613) 226-8378 Mobile (613) 864-8378
----- Original Message -----
From: "kazi " <oracledba-ezmlmshield-x59888117.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, November 30, 2007 2:59 AM
Subject: Re: export schema


>I Advise you to use also CONSITENT=YES
>
> KAzi
>
>
> Sikyala Raquel [USA] wrote:
>>
>> I did an export successfully. However, when I try to import I get errors
>> regarding roles that don't exist.
>>
>> This is the command I issued:
>>
>> exp owner=tems_adm file=/tmp/tems_adm_struct.dmp indexes=y constraints=y
>> rows=n log=/tmp/tems_adm.log
>>
>>
>>
>> -----Original Message-----
>> From: Shekhar Shinde [mailto:[Email address protected]
>> Sent: Thursday, November 29, 2007 10:41 AM
>> To: Sikyala, Raquel [USA]
>> Subject: RE: export schema
>>
>> **A LazyDBA.com subscriber has responded to your lazydba.com post**
>> **LazyDBA.com mail shield has forwarded you this email, **and removed
>> any attachments, and kept your email address secret **from this person,
>> and any viruses/trojans.
>> **If you reply to this email, the person will see your email address as
>> normal **Anything below this line is the original email text
>>
>>
>>
>> You can do SCHEMA LEVEL EXPORT of that particular schema & then IMPORT
>> it whereever you want.
>>
>> The command is :
>>
>> Exp owner=schema_name file=filename.dmp log=file_name.log
>>
>> Schema_name = name of the schema
>>
>> File_name = you can specify a convinient file name
>>
>> Thanks,
>> Shekhar.
>>
>> -----Original Message-----
>> From: Sikyala Raquel [USA]
>> [Email address protected]
>> Sent: Thursday, November 29, 2007 9:05 PM
>> To: LazyDBA Discussion
>> Subject: export schema
>>
>> I need to export a schema with all their objects. What command would I
>> issue to do this?
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> 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
>>
>>
>>
>> ========================================================================
>> ====================================================
>>
>> Disclaimer:
>>
>> This message and the information contained herein is proprietary and
>> confidential and subject to the Tech Mahindra policy statement, you may
>> review the policy at http://www.techmahindra.com/Disclaimer.html
>> externally and http://tim.techmahindra.com/Disclaimer.html internally
>> within Tech Mahindra.
>>
>> ========================================================================
>> ====================================================
>>
>>
>> ---------------------------------------------------------------------
>> 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