I know it existed in Oracle6 - and just checked my handy Oracle 6.0 SQL*Plus
v3.0 Quick Reference (circa 1991) to be sure. The only v5 manual I could
find easily is my Database Administrator's Guide for Version 5.1 (circa
1986) and it contained no information on the copy command, but I'm pretty
sure it existed then also.
Don Granaman
[OraSaurus]
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, July 07, 2002 5:13 PM
at least... I can't remember now, but I think there was a version of
copy at least as far back as version 5, when I started
--- Joe Testa <[EMAIL PROTECTED]> wrote:
> I think i rememebr using copy back in version 6.
>
> joe
>
>
> Rachel Carmichael wrote:
>
> >copy has been around for a loooong time
> >from the 8.1.7 docs
> >
> >COPY {FROM database | TO database | FROM database TO database}
> > {APPEND|CREATE|INSERT|REPLACE} destination_table
> > [(column, column, column, ...)] USING query
> >
> >and the example
> >
> >SQL> COPY FROM SCOTT/TIGER@HQ -
> >
> >
> >>CREATE SALESMEN (EMPNO,SALESMAN) -
> >>USING SELECT EMPNO, ENAME FROM EMP -
> >>WHERE JOB='SALESMAN'
> >>
> >>
> >
> >if you are copying within the same database you can leave out the
> >from/to clause. If you are logged onto one of the two databases, you
> >can leave out the from or to clause
> >
> >
> >--- Yechiel Adar <[EMAIL PROTECTED]> wrote:
> >
> >
> >>I checked the docs for 8.1.6 and 9.0.1.
> >>I think that the copy command is new in 9i.
> >>make sure that you are logged on to 9i sqlplus when you issue this
> >>command.
> >>
> >>Yechiel Adar
> >>Mehish
> >> ----- Original Message -----
> >> From: Ramon E. Estevez
> >> To: Multiple recipients of list ORACLE-L
> >> Sent: Friday, July 05, 2002 10:08 PM
> >> Subject: Copy
> >>
> >>
> >> Hi list,
> >>
> >> I am trying to copy one table from a DB 9.0.1 on Linux RH to a DB
> >>8.1.7 on NT using this statement
> >>
> >> COPY FROM RAMON@ORLNX TO RAMON@IBOR CREATE DATBAL_TMP USING
> SELECT
> >>* FROM DATOS_BALANCES;
> >>
> >> ERROR at line 1:
> >> ORA-00900: invalid SQL statement
> >>
> >> Do I need a DBLINK, if yes, is it obligatory ?
> >>
> >> TIA,
> >>
> >>
> >> Ramon E. Estevez
> >> [EMAIL PROTECTED]
> >> 809-565-3121
> >>
> >>
> >>
> >
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Sign up for SBC Yahoo! Dial - First Month Free
> >http://sbc.yahoo.com
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
