- I can't upgrade the database. In consulting, actions like that take
years of red tape.
- I don't want to move this between databases nor do i want to create a
new one to edit the long field. The field is currently only 1500
characters long and I just want to swap out 20 characters. if it
wasn't a long field, i could use the "replace" oracle function, but
that keeps giving me the ORA-00932 error.
On Oct 26, 3:11 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
> Hugh wrote:
> > I have a table where I am searching for text in a long field to be
> > replaced in Oracle 8.
>
> > I have created something like
>
> > update table_tbl
> > set FIELD =
> > replace(FIELD,'text_to_be_Replaced','new_text_to_be_inserted')
> > where FIELD like '%'||'text_to_be_Replaced'||'%'
>
> > but that does not work since you can not run an oracle function on a
> > Long field. Since this database works with 3rd party software,
> > changing the field to a CLOB is not a viable option.
>
> > any recommendations?In order of precedence
> - get rid of the software. Oracle 8.0 was desupported in the previous
> milennium.
> - put the updated records in a temporary table.
> Use the *sqlplus*!!! COPY command to replace the affected records.
> You will need to set up a database link to the database you are
> connected too.
> the COPY statement is documented in the sqlplus reference manual.
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -- Show quoted text -
Received on Thu Oct 26 2006 - 15:31:47 CDT
