DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: COPY command

Hybrid View

  1. #1
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Does anyone know the syntax for insert with this command?? I need to populate a table from one instance to another. Thanx.

  2. #2
    Join Date
    Dec 2000
    Location
    Washington DC
    Posts
    42

    COPY syntax

    Beware of the dash "-" at the end of each line it is needed on each line every time. By the way this is the fastest way to copy data from one schema to another.

    set copycommit ###

    copy -
    from /@ -
    to /@ -
    insert ACCTN_TRANS_ST_TYPE_TBL using -
    select * from ACCTN_TRANS_ST_TYPE_TBL;

    Ken Hinerman
    Data Interaction
    DBASupport@datainteraction.com

  3. #3
    Join Date
    Dec 2000
    Location
    Washington DC
    Posts
    42

    Arrow syntax

    Hey I don't know what happened the web site stripped off some of the syntax and took the info I had in greater than and less than signs to mean HTML tags so here it is again.

    COPY -
    from usr/pwd@sid -
    to usr/pwd@sid -
    ...
    ...
    ...
    Ken Hinerman
    Data Interaction
    DBASupport@datainteraction.com

  4. #4
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    So is this how the command will look like:
    -
    set copycommit 1;
    set arraysize 1000;
    copy -
    from db1/db1@db1 -
    to db2/db2@db2 -
    insert [target_table] using -
    select * from [source_table];
    -
    Thanx.

  5. #5
    Join Date
    Apr 2000
    Posts
    126

    Wink

    There is a bug with the copy command in 8.1.5. You can't do a copy ... create or copy ... insert.

  6. #6
    Join Date
    Mar 2001
    Posts
    63
    Did anyone ever find a fix for that bug? I used to use the copy command a lot, and this bug has pretty well screwed me.

    I tried to find some workaround info on Metalinks, but when they listed the bug, they said they couldn't reproduce the bug and closed the tar.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width