Re: Data Export - Burn ON CD

From: joel garry <>
Date: Fri, 29 Aug 2008 15:23:18 -0700 (PDT)
Message-ID: <>

On Aug 29, 5:01 am, "" <> wrote:
> Hello,
> I would appreciated if you provide me a step by step how to export the
> data from Oracle on my laptop to CD (where I can burn CD).
> I'm exploring free learning how to oracle and i had all the data while
> I'm learning.  I'm not able to find the results on Google what is the
> procedure of exporting the data to CD (to burn CD).
> Your help would be much appreciated.
> Thanks

There are several ways to do this, described in various places in the docs.

  1. exp/imp utility. The "old way" to do it.
  2. expdat/impdat. The "new way to do it (like Steve referred to). May still have bugs for some situations, not backward compatible.
  3. Flat files. See the utilities link on This may be best if you want the data to go some non-Oracle place.
  4. export in XE. Another flat-file way to do this, advantage is you can do it all gui.
  5. use colsep=, in sqlplus and some other settings to get a .csv file. May have "special character in data" issues.
  6. transportable tablespaces. Often fastest way to move data around, must be careful about versions and platforms.


-- is bogus.
Happy Birthday, Michael Jackson!
Received on Fri Aug 29 2008 - 17:23:18 CDT

Original text of this message