| create table error [message #57610] |
Wed, 25 June 2003 12:56  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
|
i have to table coming from sqlserver with field having varchar(31972).. and when i try to create table in oracle its not allowing me to do so.. how should i store this fields
|
|
|
|
| Re: create table error [message #57644 is a reply to message #57610] |
Thu, 26 June 2003 14:58  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
|
oracle's variable length character column is limited to 4000 (4K) characters. Anything larger, use LONG datatype (2Gig) or CLOB (4Gig). But with CLOB you will need to use Oracle Supplied Package DBMS_LOB to manipulate and see the data.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
