Re: Export on a remote host

Well Ben,

My first answer is, the question does not make sense to me. Forget the java part right now at least as it goes for me; that's another word for coffee in my lexicon and beans are what you grind up to make it with.

How can you have a schema (and presumably, data with it) on a machine, without Oracle on it? Where is it living now?

Import and Export are very formally defined words in Oracle Land. I am taking a rough guess in saying that the source machine doesn't have Oracle on it, the data on it are not stored in Oracle (therefore) and what you want to do is transfer the data to a machine that DOES have oracle on it, and plug that data into some table?

Am I even close? "Neeeeed more inpuuuuut" as Johnny Five would say.

If you can get any kind of normal ASCII flat file out of whatever that's holding the data now on the remote machine, using SQLLDR to load (not IMPORT) the data should not be a big deal.

What are we dealing with here?

RSH. "fly" <ben-13_at_caramail.com> wrote in message news:c5a802f3.0202280824.6d74882e_at_posting.google.com...
> Hi,
>
> I would to know if anyone could explain me how it is possible to do an
> export of a schema from a machine (on which nothing about oracle has
> been installed) on a machine on which the database is installed, in
> java.
>
> Thanks in advance for your help.
>
> Fly13
Received on Thu Feb 28 2002 - 11:46:49 CST