Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table Issues - A table may only have one LONG column

691624Mar 24 2009 — edited Mar 29 2009

Hey everyone,

I'm in the process of migrating a database into my new Oracle XE system. I'm getting errors stating that only one LONG column can be in a table.

The columns in the table are both basically just text boxes where users type in a couple of pages of data. Is it possible to use a different type for these columns?

During my reading, I was able to learn about LOBs, but I'm not sure if I should use these? They seem to be HUGE, when I only need at most 30kb.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2009

Added on Mar 24 2009

1 comment

856 views