RE: How to backup/restore just one schema??

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Thu, 13 May 2004 11:08:17 +0800
Message-ID: <7534CC34CD1D9F49BB05A00B9C6F20F401351F0B@antares.bcsgroup.com.sg>

use exp help=3Dy

tables=3Dabc.tables

imp help=3Dy

fromuser, touser

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of dba1 mcc Sent: 13 May 2004 10:01
To: oracle-l_at_freelists.org; oracledba_at_lazydba.com Subject: How to backup/restore just one schema??

We have a user which have 4 schemas under it. Does there has way to backup just one schema? how to restore just one schema backup to that user?

Thanks.

=09

Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=3D1808405861=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Wed May 12 2004 - 22:06:26 CDT