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]
[mailto:oracledba-ezmlmshield-x26552655.[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.

============================================================================================================================

Oracle LazyDBA home page