Home » RDBMS Server » Server Administration » LONG to CLOB
LONG to CLOB [message #233031] Tue, 24 April 2007 07:30 Go to next message
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
Re: LONG to CLOB [message #233039 is a reply to message #233031] Tue, 24 April 2007 07:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: LONG to CLOB [message #234321 is a reply to message #233031] Mon, 30 April 2007 16:39 Go to previous messageGo to next message
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
Re: LONG to CLOB [message #234322 is a reply to message #234321] Mon, 30 April 2007 16:41 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: databse got close
Next Topic: Unable to release space from table
Goto Forum:
  


Current Time: Sat Dec 03 18:06:31 CST 2016

Total time taken to generate the page: 0.07580 seconds