Re: SQL table copying

Hi,

    Yes.

    If you truly mean export (using the Oracle export utility program) just specify the full pathname of the output file using the FILE parameter.

    If you prefer you can select the entire contents of the table and spool them anyplace on your system. Just go into SQL*Plus and enter SPOOL <full_path_name> and press return. Write your select on the next line and, after it finishes running, enter SPOOL OFF and press return to complete the operation. The output will then be in the file you specified in the SPOOL statement. (Be sure to enter the SPOOL OFF statement or you won't get the file output.)

regards

Jerry Gitomer

Timothy Bowen wrote in message ...
>is there a way to take my oracle/sql table and export it to a txt file on
>another drive on my computer?
>-Thanks
>
>
>
> -**** Posted from RemarQ, http://www.remarq.com/?c ****-
> Search and Read Usenet Discussions in your Browser
Received on Wed Jun 16 1999 - 19:12:59 CEST