Re: Informix <-> Oracle export/import of tables?
Alex wrote:
From adapple@apple.com Fri Sep 23 04:43:17 1994
Received: from apple.com (apple.com [130.43.2.2]) by solomon.technet.sg (8.6.8.1/8.6.6) with SMTP id EAA00989 for <scornd11@solomon.technet.sg>; Fri, 23 Sep 1994 04:43:12 +0800
Received: from babybop.austin.apple.com by apple.com with SMTP (5.61/8-Oct-1993-eef)
id AA22020; Thu, 22 Sep 94 13:42:41 -0700
for scornd11@solomon.technet.sg
Message-Id: <9409222042.AA22020@apple.com>
Date: 22 Sep 1994 15:38:52 -0600
From: "Alex Sirota" <adapple@apple.com>
Subject: Re(2): Informix <-> Oracle export/import of tables?
To: "Nicholas Wee" <scornd11@solomon.technet.sg>
X-Mailer: Mail*Link PT/Internet 1.0.2
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"; Name="Message Body"
Content-Transfer-Encoding: quoted-printable
Status: OR
Hey there!
Thanks for all the info. I am pretty sure that this can be done using =
embedded SQL, but that means I will have to go through a large learning =
curve on the APIs of INET and SQL*NET probably.
Tell me more about DataPump and the Triznic products if you can. Addresses =
and/or phone numbers would be grand.
-Alex
`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`
`,Alex Sirota,`,`,`,`,`,`,`Genius is an African that dreams of snow.`
`,adapple@apple.com`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`-Vladimir Nabokov,`
`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`
`,http://atlantis.austin.apple.com/people.pages/adapple/adapple.html`
`,`,`,`,`,`,`,`Apple Web Server: http://www.info.apple.com`,`,`,`,`,`
`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`
InfoPump sits on an X86 machine running OS/2. The InfoPump is
accessed via an InfoPump Manager client software running on MSWindows.
From the InfoPump Manager u first declare PROFILES (configuration
information) about the databases, hostnames, user ids, passwords,
database types that u want to connect to. Then u build scripts
to access the data from whichever hostname:databasename:userid
combination. This is done via InfoPump scripts which u write
yourself in a SQL like fashion...
The current limitations of InfoPump today include
unable to perform 2 phase commit across different databases
and some difficulty in parameter passing into InfoPump scripts, eg
select ... from ... where ... = "..." must be hardcoded.
Overall, the product looks very promising for certain kinds
of applications/enterprise wide connectivity... It's easy
to use and has gateways to many databases/middleware.
Address is Trinzic Corp, 101 University Avenue, Palo Alto CA 94301
The other option is to check out Oracle Gateway to Informix. This
is a read only gateway and see if it needs to be installed on
your Informix machine. Since it's readonly, there should be no
reason why they would want to build something on the Informix
side but instead read it using I-NET.
Opinions registered here are my own... Thanks.