On Tue, Mar 4, 2008 at 6:07 AM, hrishy <hrishys@xxxxxxxxxxx> wrote: > Hi > > My version of database is 9.2.0.7 > and i was wundering if this is feasible instead of > restoring it from a backup etc.. > > I was curious as to why you would do this rather than just restore from backup. What are you trying to accomplish? Restoring from backup is much simpler, and normally quite fast for a single datafile. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist