Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Newbie's Question - RAW Vs LONG RAW

  
   Database Forums (Home) -> Oracle RSS
Next:  selecting arbitrary entries and compatability que..  
Author Message
mon

External


Since: Jun 13, 2005
Posts: 1



(Msg. 1) Posted: Mon Jun 13, 2005 3:55 am
Post subject: Newbie's Question - RAW Vs LONG RAW
Archived from groups: comp>databases>oracle>misc (more info?)
What is the difference between LONG RAW and RAW? It seems that both
represents unstructured large binary data.

 >> Stay informed about: Newbie's Question - RAW Vs LONG RAW 
Back to top
Login to vote
Michel Cadot1

External


Since: Dec 10, 2003
Posts: 219



(Msg. 2) Posted: Mon Jun 13, 2005 4:55 am
Post subject: Re: Newbie's Question - RAW Vs LONG RAW [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"mon" a écrit dans le message de
| What is the difference between LONG RAW and RAW? It seems that both
| represents unstructured large binary data.
|
|

The same than those between LONG and VARCHAR2 but no more use LONG RAW use BLOB.

See SQL Reference, section Datatypes:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sq...lements

Regards
Michel Cadot

 >> Stay informed about: Newbie's Question - RAW Vs LONG RAW 
Back to top
Login to vote
HansF

External


Since: Mar 20, 2005
Posts: 152



(Msg. 3) Posted: Mon Jun 13, 2005 10:55 am
Post subject: Re: Newbie's Question - RAW Vs LONG RAW [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Mon, 13 Jun 2005 14:51:17 +0800, mon interested us by writing:

 > What is the difference between LONG RAW and RAW? It seems that both
 > represents unstructured large binary data.

RAW - binary, limited to 2000 bytes.
Long RAW - binary up to 2 GB

From Oracle's SQL Reference manual, chapter 1, which describes all
datatypes:

===========
Note:

Oracle Corporation strongly recommends that you convert LONG columns to
LOB columns as soon as possible. Creation of new LONG columns is scheduled
for desupport.

LOB columns are subject to far fewer restrictions than LONG columns.
Further, LOB functionality is enhanced in every release, whereas LONG
functionality has been static for several releases. See the
modify_col_properties clause of ALTER TABLE and TO_LOB for more
information on converting LONG columns to LOB.
===========

That document is available at <a rel="nofollow" style='text-decoration: none;' href="http://docs.oracle.com" target="_blank">http://docs.oracle.com</a>

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***
 >> Stay informed about: Newbie's Question - RAW Vs LONG RAW 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Newbie Question on Upgrade - We are in a dilemma whether to upgrade our database to Oracle 9i or 10gR2. Does it make sense to upgrade to 9i now? What are the factors to be considered while deciding between these two? Thank you.

NEWBIE QUESTION: BEST WAY TO LEARN ORACLE DB -

Newbie table backup question - Hi All, Isn't it possible to backup an existing table using the following syntax? create table mytable_backup as select * from mytable? This isn't working on my 10g. mytable has like 40 columns and I don't want to go thru the effort of first running a....

Newbie question re refreshing Materialized Views - Hi Sorry if this is a dumb question. I HAVE spent a fair while googling about the place trying to work this out for myself, but have drawn a blank. I will continue with Google after submitting this. We have some sort of glitch on our Oracle box at..

Newbie question - Missing Enterprise manager console? - I just started an online Oracle dba class and installed 10g Enterprise. I'm not sure why, but Enterprise manager console is not anywhere on the start menu. I've tried re-installing and checked the options to make sure that I didn't miss an option to....
   Database Forums (Home) -> Oracle All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]