Works for me: set buffer 1000000000 use the sqplus on dos..ie. sqlplus.exe Thanks to Ashish Volker Sch�n E-Mail: mailto:[EMAIL PROTECTED] 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@instance TO user/pw@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@instance TO user/pw@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:[EMAIL PROTECTED] http://www.inplan.de -----Urspr�ngliche Nachricht----- Von: Ashish Arole (CTS) [mailto:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED] http://www.inplan.de -------- Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] 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 -------- Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
