On Aug 7, 2:39 pm, pascal.dull..._at_veda.net wrote:
> Hello!
> I've got a problem with byte values in Oracle (version 10g). I need to
> store a fixed number of bytes. Usually it's less then 10 kilobytes. I
> tried to use the data type RAW, but there is a limitation that only
> one column of this type may be created in a table. But I need more
> than one column per table. Then I tried to use BLOB, but BLOB fields
> can't be used in the primary key. As I need to migrate an existing
> database, I have no influence on the primary key. I need it, so that
> the unique constraint is correct.
> I tried to use NCHAR columns as well, but some byte values seem to be
> unbound. The value I read from the database is not the same that I
> have written.
>
> Does anybody have an idea for this?
>
> Best regards
> Pascal
What you want can not be done in Oracle.
Could you please explain what is the business need for a 'less than
10k' primary key?
What are you converting? A database or a garbage plant?
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Aug 07 2007 - 07:56:38 CDT
