When you export by owner you do not get any roles exported. You need to create these roles manually on the other database if you need them.

-----Original Message-----
From: Sikyala Raquel [USA] [mailto:oracledba-ezmlmshield-x78039726.[Email address protected]
Sent: Thursday, November 29, 2007 1:54 PM
To: LazyDBA Discussion
Subject: RE: export schema


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