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
>
>
>
>
>


Oracle LazyDBA home page