Re: How to transfer varchar2 to long raw

tamsun wrote:
On Thu, 31 Aug 2006 02:40:05 GMT, "IANAL_VISTA"
<IANAL_Vista@xxxxxxxxxxx> wrote:

tamsun <tamsun@xxxxxxxxx> wrote in news:f1gcf299gkpta5h69tikqr4h040vl1rb9t@xxxxxxx:

hi, I have a question:

I hava a table, such as:

Table: T1
Field:
ID varchar(38),
VALUE varchar(4000),

Now I need modify table structure to:
Table: T2
Filed:
ID varchar(38),
VALUE long raw

My question is:
As filed "VALUE" had be changed to long raw,
how to move old record into new table T2 by SQL,
e.g. how to insert a string(such as "Hello World") into long raw filed by pure sql.

INSERT INTO T2 SELECT * FROM T1;


I try this sql,but error occur:
ORA-01465: invalid hex number

Read Brian's comment. You need LONG, not LONG RAW. But more importantly
this data type has been deprecated and your move makes little sense. Why
not a CLOB?

Also both of your column names are reserved words in Oracle. A very bad
choice so consider changing your column names to avoid problems.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: best practice on migrating long RAW to blob
    ... Should I just "modify" as ... the data, clearing the long raw column and then dropping it, re- ... unable to extend temp segment by 8192 in tablespace USERS) ... Puget Sound Oracle Users Groupwww.psoug.org ...
    (comp.databases.oracle.misc)
  • Re: How to transfer varchar2 to long raw
    ... I hava a table, such as: ... Now I need modify table structure to: ... As filed "VALUE" had be changed to long raw, ... into long raw filed by pure sql. ...
    (comp.databases.oracle.misc)
  • Re: How to transfer varchar2 to long raw
    ... I hava a table, such as: ... Now I need modify table structure to: ... As filed "VALUE" had be changed to long raw, ... into long raw filed by pure sql. ...
    (comp.databases.oracle.misc)
  • How to transfer varchar2 to long raw
    ... I hava a table, such as: ... Now I need modify table structure to: ... As filed "VALUE" had be changed to long raw, ... into long raw filed by pure sql. ...
    (comp.databases.oracle.misc)
  • Re: How to transfer varchar2 to long raw
    ... As filed "VALUE" had be changed to long raw, ... e.g. how to insert a stringinto long raw filed by pure sql. ... The LONG RAW datatype is used for BINARY data while the VARCHAR2 datatype is used for character data. ...
    (comp.databases.oracle.misc)
Quantcast