copy tables from one database to another
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: copy tables from one database to another

  1. #1
    Join Date
    Nov 2000
    Posts
    15
    I am trying to copy a table from one database to another using:

    copy from hcfa5/hcfa5@dmdb-
    create hcfa.dis_doc_rename -
    using select * from hcfa5.dis_doc_rename;

    but I am getting a 'fetch out of sequence' error

    what am I doing wrong???

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    hmm... but you can always export and import.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Is that database (dmdb) a non-oracle data source? I have seen this error using a DB Link to an AS/400 DB/2 box.

    The way we got around it was to create the structure of the source table on the destination database and then use:
    insert into x select * from x@dblink;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Oct 2000
    Posts
    4
    No need to create structure also. Just say

    Create table my_table as select * from his_table@dblinkname;

    This should work.




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