Re: Help - Export/Import a Row

Hi Joe,

I don't know how to export and import a single row, but you might consider creating a separate table similar to the one containing the row you need:

CREATE TABLE smalltable
AS SELECT * FROM largetable
WHERE .... (where clause selecting the row you need)

Next, you can make an export file containing only smalltable, import it in another database, and re-insert the row there. It's a workaround, but at least a more convenient and more generic one than using spool and SQL*Loader.

Good luck,

Paul.

Joe Gervais <vole_at_primenet.com> wrote in article <6i51qo$ft5_at_nntp02.primenet.com>...
> Howdy Folks,
>
> Sorry if this is in the FAQ, but I couldn't find it.
> Can anyone help me figure out how to export a database
> row from a single table to file, and then import the
> row back into an equivalent table in another database
> (on a separate network).
>
> I'm looking into spool and sqlload, but that seems like
> overkill. Is there an easier way to do this?
>
> Thanks in advance!
>
> Cheers,
>
> -Joe, vole_at_primenet.com
>
> "And that, my Liege, is how we know the Earth
> to be banana-shaped." -- Monty Python and the Holy Grail
> --
>
Received on Tue Apr 28 1998 - 14:50:17 CDT