OraFAQ Forum: Server Administration » Copying LONG datatype from one table to another

Home » RDBMS Server » Server Administration » Copying LONG datatype from one table to another

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Copying LONG datatype from one table to another [message #370390]

Fri, 17 September 1999 12:19

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.

Report message to a moderator

Re: Copying LONG datatype from one table to another [message #370392 is a reply to message #370390]

Fri, 17 September 1999 15:34

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

Report message to a moderator

Re: Copying LONG datatype from one table to another [message #370393 is a reply to message #370392]

Fri, 17 September 1999 16:11

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.

Report message to a moderator

Re: Copying LONG datatype from one table to another [message #370395 is a reply to message #370390]

Fri, 17 September 1999 17:20

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.

Report message to a moderator

Re: Copying LONG datatype from one table to another [message #370397 is a reply to message #370395]

Sat, 18 September 1999 14:14

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

Report message to a moderator

Re: Copying LONG datatype from one table to another [message #370401 is a reply to message #370397]

Mon, 20 September 1999 10:03

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???

Report message to a moderator

Re: Copying LONG datatype from one table to another [message #370421 is a reply to message #370401]

Wed, 22 September 1999 16:32

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.

Report message to a moderator

Previous Topic:	difference in primary key vs unique+not null
Next Topic:	Oracle equivalence for SqlServer #temp_table?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 25 08:16:38 CDT 2025