Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.3.2.3 import performance
In article <6e668p$1hho$1_at_ausnews.austin.ibm.com>,
Jim <jimmorgan_at_csi.com> wrote:
>I think it's horrible the Oracle does not provide an easy way to export =
>data into a comma-delimited file, like every other database on the =
>planet does. You can create a comma-delimited file by using SQL*PLUS =
>and the spool command, but you have to turn off all of the headings, =
>page breaks, etc to get it to work.
>
>This is especially stupid since Oracle does support loading their tables =
>with comma-delimited files. So they make it easy to switch your =
>database to Oracle but difficult to switch your database away from it.
>
>I'd recommend getting the book 'Oracle for Dummies' which actually gives =
>an example of how to do this.
It is so trivial to do that the complaint is pretty silly.
It's only a problem when you are already out of time because the import is taking too long.
-- These opinions are my own and not necessarily those of Information Quest jgarry@eiq.com http://www.informationquest.com http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA!Received on Thu Mar 12 1998 - 00:00:00 CST