Home » RDBMS Server » Server Administration » Copying LONG datatype from one table to another
Copying LONG datatype from one table to another [message #370390] Fri, 17 September 1999 12:19 Go to next message
Tim Tong
Messages: 3
Registered: September 1999
Junior Member
HI. Anyone know a solution of copying a column (long datatype) from one table to another? The two tables are not identical. Any info would be much appreciated.

Tim.
Re: Copying LONG datatype from one table to another [message #370392 is a reply to message #370390] Fri, 17 September 1999 15:34 Go to previous messageGo to next message
m a sivan
Messages: 34
Registered: July 1999
Member
u can use a PL/sql to do that. fetch the data into some variable of long type and then insert into the new table...

Thanks
Re: Copying LONG datatype from one table to another [message #370393 is a reply to message #370392] Fri, 17 September 1999 16:11 Go to previous messageGo to next message
Tim Tong
Messages: 3
Registered: September 1999
Junior Member
Thank you for the response. I was hoping for some simple sql or utility that might do the job.
Re: Copying LONG datatype from one table to another [message #370395 is a reply to message #370390] Fri, 17 September 1999 17:20 Go to previous messageGo to next message
Prashanth
Messages: 41
Registered: September 1999
Member
Try this COPY COMMAND in sql*plus

COPY TO x/y@z-
CREATE PO1 USING-
SELECT X1_PK,Y1,PO FROM XYZ;

where x/y@z is usrname/password@hoststring
and po1 is dummy table.
xyz table having a long column.
Re: Copying LONG datatype from one table to another [message #370397 is a reply to message #370395] Sat, 18 September 1999 14:14 Go to previous messageGo to next message
sonik chopra
Messages: 4
Registered: September 1999
Junior Member
dear prashanth,
long datatype cannt be copied in this fashion because I havr already tried this thing.
if it works perfectly with you thenI will be obliged to receive your Email.
with thanks

sonik
Re: Copying LONG datatype from one table to another [message #370401 is a reply to message #370397] Mon, 20 September 1999 10:03 Go to previous messageGo to next message
m a sivan
Messages: 34
Registered: July 1999
Member
Yeah even i thought that way and thats why I wrote a PL/SQL and declared another LONG and fetched data and did that COPYING.. anywway do let me know too if that happens.
Tim did u try???
Re: Copying LONG datatype from one table to another [message #370421 is a reply to message #370401] Wed, 22 September 1999 16:32 Go to previous message
Tim Tong
Messages: 3
Registered: September 1999
Junior Member
The copy cmd doesn't not work because the two tables are not identical. Declaring a long variable in pl/sql as a container still has it restrictions. The long datatype in pl/sql is limited to 3k.
Previous Topic: difference in primary key vs unique+not null
Next Topic: Oracle equivalence for SqlServer #temp_table?
Goto Forum:
  


Current Time: Tue Oct 20 10:20:01 CDT 2020