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

Thread: replication

  1. #1
    Join Date
    May 2001
    Posts
    736

    Question

    Hello,
    I created snapshot at remote site.From the oracle manuals it is noted that Oracle 8i will not support the LONG and LONG RAW datatypes,actually we are going to install a outside vendor application on remote site in which one of table consist of LONG datatype which is used to capture the images of people,since Oracle will not support this datatype,can any one tell which datatype will replace the LONG so that it will not affect the replication.
    Thank u

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi

    Oracle reccomends to use Blob datatype for binary large objects and Clob for character large objectsin case you need to store these binary data within database.if you need to store binary data outside database at os level you could use bfiles.

    regards
    hrishy

  3. #3
    Join Date
    May 2001
    Posts
    736
    Hello hrishy

    When i attempt to change it to BLOB or CLOB the database is saying u are attempting a invalid datatype.Whats the problem
    Regards
    Akhadar

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi

    what are you attempting at could you show me the steps.you cannot directly convert a long data type to blob or clob .you will have to spoll the data to a text file and create a table with a blob or clob data type nad then load this table using sqldr.

    kindly refer to this thread for more details
    http://www.dbasupport.com/forums/sho...?threadid=8170

    regards
    hrishy

  5. #5
    Join Date
    May 2001
    Posts
    736

    Thumbs up

    Thank u very much for your detail explanation including the explanation given in your previous thread.
    Regards
    akhadar

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