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

Thread: Replication

  1. 07-04-2001, 03:06 AM #1
    akhadar
    akhadar is offline Advisor
    Join Date
    May 2001
    Posts
    736
    Hello,
    Can any one tell me why it is not possible to execute the funtion TO_LOB for loading data from LONG RAW datatype into LOB in oracle version 8.0.5 but it is successfully executed in Oracle version 8i.Is there any alternative method to load the data from LONG RAW to LOB other than SQL loader.
    Thank u
    Regards
    akhadar
    Reply With Quote Reply With Quote
  2. 07-04-2001, 06:58 AM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi

    you can use insert with select statement and use to_lob function to convert




    regards
    hrishy
    Reply With Quote Reply With Quote
  3. 07-04-2001, 07:49 AM #3
    akhadar
    akhadar is offline Advisor
    Join Date
    May 2001
    Posts
    736
    Hello hrishy,

    I tried with the same option i.e.,using insert and select statements with to_lob function but in oracle 8.0.5 it says that invalid column and datatype,since i got this problem as iam going to have a replication and it will not support the long raw.
    At destination i want to install oracle 8i the same statements very well executed in oracle 8i.I want to why this not in Oracle 8.0.5.Can u clarify this.
    Regards
    akhadar
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width