Help Required
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Help Required

  1. #1
    Join Date
    Apr 2001
    Posts
    51
    Can anybody tell me how to copy data from a table when a
    LONG or LONG RAW column exists.

    Thanks.

  2. #2
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122

    Smile hmm..

    I need to know how u will copy the data? from table to table or what is the case...! if it is table to table try using the copy command and select the columns from the table you want a copy..or you can create table as selecyt * from source.

    Write me what exactly u want i will see if i do something for ya..

    Regards,
    NK

  3. #3
    Join Date
    Apr 2001
    Posts
    51

    Urgent Help Required !!!!!!

    Hello nabeel

    suppose i have a table tab1 which contains columns like empno number and details long data type. This table contains some data. Now i need to create based upon this table tab1.

    But the problem is when a table contains a long column this syntax doen't work.

    create table tab2 as
    select * from tab1;

    Hope now the question is clear.

    Thnaks

  4. #4
    Join Date
    Mar 2001
    Posts
    32
    Hi

    The simpler solution for above would be Exporting
    Data and Importing Data into required table.

    I dont find any other solution for this...

    Any answer from any friends..

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