Results 1 to 3 of 3

Thread: table data dump

  1. #1
    Join Date
    Oct 2003
    Posts
    15

    Unanswered: table data dump

    hi i m trying to dump data from table A to table B in different schema but same instance. now table A has column that has different data values then table B. for example
    TABLE A. identification_no varachar(5)
    TABLE B .reference_id varchar(15)
    can someone help me with the script here they are pretty big tables.

  2. #2
    Join Date
    Oct 2003
    Posts
    22

    Re: table data dump

    U would surely loose data if the resultant's table column is smaller in size.
    Make them same and then copy.
    Also make sure that the corresponding column's datatype are the same, else use explicit functions to change them.
    Last edited by stephen_pe; 10-24-03 at 10:33.

  3. #3
    Join Date
    Oct 2003
    Posts
    87

    Re: table data dump

    Originally posted by mehak
    hi i m trying to dump data from table A to table B in different schema but same instance. now table A has column that has different data values then table B. for example
    TABLE A. identification_no varachar(5)
    TABLE B .reference_id varchar(15)
    can someone help me with the script here they are pretty big tables.
    As long as the target columns are larger in width or scale/percision you're OK. IF they aren't the same datatype you'll have to convert them while selecting from the source. If conversions are necessary, consider using the SQL/LOADER.
    Oracle - DB2 - MS Access -

Posting Permissions

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