SOLVED: Copying table with LONG column (using copy getting ORA-01

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Thu, 09 Aug 2001 12:05:06 -0700
Message-ID: <F001.00365908.20010809084450@fatcity.com>

Works for me:

set buffer 1000000000

use the sqplus on dos..ie. sqlplus.exe

Thanks to Ashish

Volker Schön
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Ursprüngliche Nachricht-----

Von: Schoen Volker
Gesendet: Donnerstag, 9. August 2001 12:50 An: LazyDBA.com Discussion
Betreff: AW: Copying table with LONG column (using copy getting ORA-01458) Hi Ashish, hi list,

copy command doesn't work in my environment, get ORA-01458 error. I searched metaling fór a workarround, but the suggested workarround doesn't do it.

(workarround)
1. To create the new table and not copying the data do: COPY FROM user/pw_at_instance TO user/pw_at_instance CREATE FUHRPARK_KOPIE USING SELECT * FROM FUHRPARK WHERE 1=2; 2. To insert the data to the new table do: COPY FROM user/pw_at_instance TO user/pw_at_instance APPEND FUHRPARK_KOPIE USING SELECT * FROM FUHRPARK; getting error (in german):
Array-Fetch-/Bindungsgröße ist 15. (Arraygröße ist 15) Nach Beendigung erfolgt Commit. (COPYCOMMIT ist 0) Maximale LONG-Größe ist 80. (LONG ist 80)

ERROR:
ORA-01458: Ungültige Länge in variabler Zeichenfolge

My environment is:
Oracle 8.1.5 on Windows NT SP6
Client SQPLUS 8.1.7.0.0

Maybe someone knows another workarround or knows which oracle path to apply.

Volker Schön
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Ursprüngliche Nachricht-----

Von: Ashish Arole (CTS) [mailto:AshishA_at_pun.cognizant.com] Gesendet: Donnerstag, 9. August 2001 12:31 An: Schoen Volker; LazyDBA.com Discussion Betreff: RE: Copying table with LONG column

Use the COPY command from SQL plus

-----Original Message-----

Sent: Thursday, August 09, 2001 3:25 PM
To: LazyDBA.com Discussion

Does someone know how to copy a table with a long column? Export/Import works, but I like to do it with SQL.

TIA Volker Schön
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful.
Visit us at http://www.cognizant.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 09 2001 - 14:05:06 CDT