RE: Need sqlplus routine to export/import data on a unix box

Howard,
You can run export/import via Sqlnet.
Ex: exp scott/tiger_at_orcl .......
HTH.....
-----Original Message-----
From: Horowitz, Howard [mailto:Howard.Horowitz_at_reuters.com] Sent: Friday, December 01, 2000 5:11 PM
To: Multiple recipients of list ORACLE-L Subject: Need sqlplus routine to export/import data on a unix box from

Problem: I'm on an NT box running sqlplus and I need a script to export/import data from "schema a" to "schema b". Both "schema a" and
"schema b" are located

in an Oracle instance on a unix(solaris) box. The user would like to export/import the data via VB application/sqlplus.

1. Is there a way to run the export/import command from sqlplus? I'm not sure how to do this without writing a shell script / telneting from nt to unix.
2. Does anyone know of a sql script OR procedure that dynamically creates insert statements for table data?

Thank you in advance,

Howard

        Visit our Internet site at http://www.reuters.com

Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Horowitz, Howard
  INET: Howard.Horowitz_at_reuters.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




"WorldSecure Server <baking.bestfoods.com>" made the following

 annotations on 12/01/00 18:10:26
----------------------------------------------------------------------------
-
The origin of this electronic mail message was the Internet.
Bestfoods Baking cannot validate the authenticity
of the sender and therefore cannot be held accountable
for any content within.
=======================================================





"WorldSecure Server <baking.bestfoods.com>" made the following

 annotations on 12/01/00 18:52:34
-----------------------------------------------------------------------------
This message may contain confidential and trade secret information of Bestfoods Baking, and be subject to the Economic Espionage Act of 1996. For recipient's use only. If you have received this message in error, please delete immediately, and alert the sender.