Re: export data
Date: Tue, 18 Mar 2008 07:51:27 -0700 (PDT)
On 18 Mar, 01:20, "learning_co..._at_hotmail.com" <learning_co..._at_hotmail.com> wrote:
> 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.
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