Re: Transferring Table between Systems

In article <3n9je7$5cc_at_booch.legent.com> Alvin Moore <amoore_at_vienna.legent.com> writes:
> I am running Oracle 6.x under a Sequent server within
>a UNIX System V Release 3.2.0 i386 environment. In order to
>view a few of the tables within MS Access, I want to transfer
>several of the tables onto my pc. Unfortunately though, the
>box is not networked and does not have a floppy disk. It does
>however have a tape drive and a modem installed. I am currently
>accessing the box via modem and a terminal emulator. I can
>consequently transfer ASCII files but not binary files in which
>those tables are composed.

CHAZ>	95-04-27 Thu (Portland, OR)
	Given your transport restrictions I'd say that you'd have
	to create the tables on your PC then extract the data on
	the server using SQL and saving it in a text file.  You
	can then transfer the text file to the PC and load it into
	the table using SQL or the loader.  Using the loader will
	require you to generate the text file with the proper
	field delimiters.  I would not recommend this process for
	large amounts of data.  Start off with a modest row count
	to see what the transfer pain is and to debug the process.
	If the time involved gets too long I think you'll have to
	consider a network connection or something like tape media.
	Good luck.