1. Export - Import 2. Recover the database to another location and drop all schemas other than the one you need [and of course, SYS, SYSTEM, OUTLN etc ] Hemant At 10:01 AM Thursday, you wrote: >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. > > > > >__________________________________ >Do you Yahoo!? >Yahoo! Movies - Buy advance tickets for 'Shrek 2' >http://movies.yahoo.com/showtimes/movie?mid=1808405861 >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >put 'unsubscribe' in the subject line. >-- >Archives are at //www.freelists.org/archives/oracle-l/ >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://web.singnet.com.sg/~hkchital ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------