Re: Help - Export/Import a Row

Joe,

The following should work;

1. export the table. exp username1/passwd1
2. import the table to a temporary user, say joe imp system/passwd file=expdat.dmp fromuser=username1 touser=joe tables=tablename
3. sqlplus joe/passwd delete all records except the one you require
4. export the table from joes schema
5. ftp the file and import the table into the other database imp system/passwd file=expdat.dmp ignore=y fromuser=joe touser=newuser tables=tablename (The ignore=y will insert the record regardless of whether the table already exists.)

This method works well if the table contains long raws as you cant do a 'create table as select.........' when tables contain long raws.

Hope this helps
Mick

Joe Gervais wrote:

> 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 Wed Apr 29 1998 - 00:59:09 CDT