Hello all,
Yes, it is another Oracle 8.0 question. We are just too small to force our
customer to migrate to newer Oracle.
My problem is I need to copy the value of the long column in table A to
another table B's long column.
Unfortunately, "insert into table_a select long_column from table_b"
doesn't work. I also thought of changing table_a's long column to clob,
and convert table_b.long_co lumn to clob before inserting into table_a, but
to_lob() doesn't exist in Oracle 8.0.
So is this my only option: dumping table_b.long_co lumn to a file and
loading it back to table_a.long_co lumn?
Thanks in advance!!!
- Will 3 12184
On Tue, 30 Sep 2003 20:55:26 GMT, jcwhui
<j_c_w_h_u_i@ho t_mail.company> wrote: My problem is I need to copy the value of the long column in table A to another table B's long column.
Unfortunatel y, "insert into table_a select long_column from table_b" doesn't work. I also thought of changing table_a's long column to clob, and convert table_b.long_co lumn to clob before inserting into table_a, but to_lob() doesn't exist in Oracle 8.0.
So is this my only option: dumping table_b.long_co lumn to a file and loading it back to table_a.long_co lumn?
Investigate the use of the SQLPlus COPY command. This can transfer
longs.
Here's a link to the FAQ: http://www.orafaq.com/faqplus.htm#COPYLONG
Kind regards
Dale
Need to get the DDL out of a schema (or database)? Check out our
freeware DBATool. http://www.DataBee.com/dt_home.htm
Dale Edgar <Da**@DataBee.c om> wrote in
news:tc******** *************** *********@4ax.c om: On Tue, 30 Sep 2003 20:55:26 GMT, jcwhui <j_c_w_h_u_i@ho t_mail.company> wrote:
My problem is I need to copy the value of the long column in table A to another table B's long column.
Unfortunately , "insert into table_a select long_column from table_b" doesn't work. I also thought of changing table_a's long column to clob, and convert table_b.long_co lumn to clob before inserting into table_a, but to_lob() doesn't exist in Oracle 8.0.
So is this my only option: dumping table_b.long_co lumn to a file and loading it back to table_a.long_co lumn?
Investigate the use of the SQLPlus COPY command. This can transfer longs.
Here's a link to the FAQ: http://www.orafaq.com/faqplus.htm#COPYLONG
Kind regards Dale
I doubt this will work for me. My code is inside a stored procedure. And
in fact I meant to copy 1 particular row from table_b to table_a, i.e.
"insert into table_a select long_column from table_b where id=123"
I guess external file access is my only option now. Thanks anyway!
- Will
jcwhui wrote: Dale Edgar <Da**@DataBee.c om> wrote in news:tc******** *************** *********@4ax.c om:
On Tue, 30 Sep 2003 20:55:26 GMT, jcwhui <j_c_w_h_u_i@ hot_mail.compan y> wrote:
My problem is I need to copy the value of the long column in table A to another table B's long column.
Unfortunatel y, "insert into table_a select long_column from table_b" doesn't work. I also thought of changing table_a's long column to clob, and convert table_b.long_co lumn to clob before inserting into table_a, but to_lob() doesn't exist in Oracle 8.0.
So is this my only option: dumping table_b.long_co lumn to a file and loading it back to table_a.long_co lumn?
Investigate the use of the SQLPlus COPY command. This can transfer longs.
Here's a link to the FAQ: http://www.orafaq.com/faqplus.htm#COPYLONG
Kind regards Dale I doubt this will work for me. My code is inside a stored procedure. And in fact I meant to copy 1 particular row from table_b to table_a, i.e. "insert into table_a select long_column from table_b where id=123"
I guess external file access is my only option now. Thanks anyway!
- Will
Insert all data, except the long, then update the long.
Didn't try, but works for LOB across dblinks...
--
Regards, Frank van Bortel This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: jonathan |
last post by:
hey all,
I realize that this question might pop up from time to time, but I
haven't seen it a while and things might of changed, so -
Right now (July 2004) how does mysql stand up in comparison to oracle?
We are seriously considering migrating our multi-processor oracle
system to mysql to save on licensing costs, and would need several
features that mysql may or may not have:
|
by: jrefactors |
last post by:
I want to know the differences between SQL Server 2000 stored
procedures and oracle stored procedures? Do they have different
syntax? The concept should be the same that the stored procedures
execute in the database server with better performance?
Please advise good references for Oracle stored procedures also.
thanks!!
|
by: BigDaDDY |
last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going
to be kicked back in my chair eating popcorn and watching football 10 years
from now, while all you clowns are scrambling to rewrite all your code
because Microsoft upgraded all their crap and nothing you wrote 10 years
earlier works. It doesn't take a rocket scientist to figure out that
Microsoft is unreliable. Try opening an Excel 95 spreadsheet you wrote in...
|
by: jmev7 |
last post by:
Any way to avoid having to manually enter my user name & password for
the Oracle login box? I normally run a query on an attached Oracle
table and have to enter the un/pw before the query will run. There's
no place to enter this information in. Later, if I run subsequent
queries on the table in question, I don't need to enter un/pw again. I
can leave my PC on 24x7, but that's not really a solution. I need to
know if I can log in to the...
|
by: Andrew Arace |
last post by:
I scoured the groups for some hands on code to perform the menial task
of exporting table data from an Access 2000 database to Oracle
database (in this case, it was oracle 8i but i'm assuming this will
work for 9i and even 10g )
No one had what I needed, so I wrote it myself.
I Rule.
This code isn't going for efficiency, and isn't trying to be dynamic.
It doesn't create the table structure in Oracle, that's up to you. (I
| |
by: peter.morin |
last post by:
Issue: I am inserting an Oracle record containing insert trigger via
Access 2002 using the code below. The issue is that the sequence from
the acSaveRecord is not reflected after the insert so the insert into
the second table section: ' Copy LOB entries now. fails on unique
index constraint (understandable because it has the orig rate_id).
The strange thing is that it works fine for new records that have
beend added and then...
|
by: Ashish Patankar |
last post by:
I want to migrate my Oracle 10g database to Db2. I want some
documentation for the comparision between these to databases. I also
want to know which features of Oracle 10g are supported by Db2 and
which are not supported.
|
by: Chris Leonard |
last post by:
James - you could be running into a known issue with installing Oracle8i
software on a P4. Here is a plain-text section of our internal
documentation of the issue:
Subject/Title: Installing Oracle software on Pentium 4 computers
Category: Oracle, Oracle Client Software ITS area: Administrative
Information Systems
When trying to install some Oracle8i software on a PC with a Pentium 4
processor, JREW.EXE may fail to launch the...
|
by: jcwhui |
last post by:
Hello all,
Yes, it is another Oracle 8.0 question. We are just too small to force our
customer to migrate to newer Oracle.
My problem is I need to copy the value of the long column in table A to
another table B's long column.
Unfortunately, "insert into table_a select long_column from table_b"
doesn't work. I also thought of changing table_a's long column to clob,
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |