Large data type

[florida1987]

I have a text field that has a data type of varchar2(4000).
I would like to change it to hold 10,000 but I dont think it can go that big.

Please advise how I can do it?

 

[KenCunningham]

Sounds like you need to create a CLOB column:

http://www.ss64.com/orasyntax/datatypes.html

I want to be good, is that not enough?

 

[florida1987]

Thanks, I added the CLOB to my table but it only takes 4000 max characters. How do I add more?

 

[SantaMufasa]

I added the CLOB to my table but it only takes 4000 max characters.

What leads you to believe that the CLOB columns has a 4000-character limit? Please post a copy of the evidence here.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[florida1987]

I created the CLOB datatype (called BigField) in my table but when I try and add text info to the CLOB field it seems to not add anymore than 4000 characters.

INSERT INTO TableOne
(BigField)
VALUES
('dsfadfasdfasdfadsfetaere etc....more than 4000 characters here..');

 

[SantaMufasa]

Florida, I am puzzled. I have a table with two rows. The following DESC and query the table:

desc clobber

 Name                    Null?    Type
 ----------------------- -------- -------------
 PATHNAME                         VARCHAR2(100)
 FILENAME                         VARCHAR2(100)
 CONTENT                          CLOB

select length(content) from clobber;

LENGTH(CONTENT)
---------------
           4171
          64000

As you can see, both rows contain entries greater that 4000 in length.

Could you please run a LENGTH(<CLOB column name>)-query against your table and please post the results back here?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[florida1987]

Thanks for your time.

I actually created it using OEM. I will do as you advised tomorrow morning.

 

[SantaMufasa]

Florida, that is a good idea (to use something besides OEM, such as SQL*Plus). I just responded to thread759-1471223 in which the OEM behaviour, as it relates to changing the characteristics of a column, is flakey...if things behave properly from the SQL*Plus prompt, then the two of you posters have at least "tripped over" (and possibly discovered for reporting to Oracle) a bug in OEM.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Thargy]

also, Florida, you might have run into the limitations of sqlplus. I believe that there is a line length limit of roughly 4,000 characters, which would limit the amount of data entered into your CLOB (assuming that you were using sql plus for the job).

Regards

T