From: "CA" Newsgroups: comp.databases.oracle.server Subject: Are binary columns difficult to replicate? Lines: 13 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: X-Trace: /wmC6Av+9RJaEcjX3p9wTqVT5sBcvM5MybxzRHYHU/IZKNmGd8yt1bC/SqrhuWKRJSXxzLfJB1c6!jIkrzKfeLjnHs92S7geYyKW07k9UoyWKwPeiruxdJxlaeoE2qDxWggF5zW/ieXXmBJIY3lDGZFbB!WceUHs+taBA= X-Complaints-To: abuse@gte.net X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly NNTP-Posting-Date: Sat, 09 Sep 2000 22:24:09 GMT Distribution: world Date: Sat, 09 Sep 2000 22:24:09 GMT Here's a question from a data modeling perspective: I've been designing an 8i database to store articles which can be up to 10K in length. Since the varchar2() datatype maxes out at 4K, I used a CLOB column to store the article. My lead DBA is complaining about the binary column, saying he can't replicate it to other instances (e.g., from DEV to PROD). Is it really a problem to replicate binary columns? Seems odd Oracle would add the datatype but not allow it to be replicated. Thanks for your time.