OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » LONG to CLOB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LONG to CLOB [message #233031]

Tue, 24 April 2007 07:30

atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai

Member

Hi Experts,

Need Information:

1. Tables need to migrate from LONG datatype to LOB datatypes (BFILE, BLOB, CLOB, and NCLOB).

2. Oracle recommends migrating any LONG data to the CLOB type, and any LONG RAW data to the BLOB type

pls comment.

Thnx
Atul

Report message to a moderator

Re: LONG to CLOB [message #233039 is a reply to message #233031]

Tue, 24 April 2007 07:50

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you posting all your interview questions?

Nothing to comment, do what Oracle says.

Regards
Michel

Report message to a moderator

Re: LONG to CLOB [message #234321 is a reply to message #233031]

Mon, 30 April 2007 16:39

Mishtry
Messages: 1
Registered: April 2007
Location: Manila

Junior Member

Hi,
Am new here, hope i wont get any violent reaction with my reply.
My answer is actually by the book.

So here it goes.

LONG is only used for backward compatibility. So i guess, the reason Oracle suggests to use CLOB instead of LONG datatype because maybe in the future release of Oracle, LONG will soon be decommissioned. Razz

Report message to a moderator

Re: LONG to CLOB [message #234322 is a reply to message #234321]

Mon, 30 April 2007 16:41

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is exactly what we said.
Don't take this as a violent reaction. Wink

Regards
Michel

Report message to a moderator

Previous Topic:	databse got close
Next Topic:	Unable to release space from table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:40:59 CDT 2024