Re: export data

On 18 Mar, 01:20, "learning_co..._at_hotmail.com" <learning_co..._at_hotmail.com> wrote:
> Hi,
>
> I'm learning how to use oracle 11g.  I use SQL Development and try to
> learn how to export my data in oracle to a file for my backup.  I want
> to burn a file on CD and transfer to other computer to import the
> file.   I'm trying to look for the code how to excute the scripts to
> export the file into the folder and then burn CD and how to import the
> file into other computer.
>
> Your help would be much appreciated.
>
> Thanks

You can use RMAN to backup (or duplicate, as others have suggested) your database. http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmquick.htm#BABJAGIB

To export a subset of your data, look into using Data Pump: http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/dp_overview.htm#i1009203

HTH -g Received on Tue Mar 18 2008 - 09:51:27 CDT