Dear All, Sudah resolved. Tadi gunakan ide dari Kahfi Heryandi Suradiradja, kemarin sempat gunakan cara "bodoh", drop table dan create table dengan struktur yang baru (data type berubah dan length bertambah).
Thanks, guys... Have a nice day. Regards, Peter Gunawan Phone: (62)-(21) 3506969 ext.2055 Please consider the environment before printing this e-mail -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Riky Andrian Sent: Tuesday, March 22, 2011 10:05 AM To: [email protected] Subject: RE: [indopb] Error sewaktu alter table Kolom yg sudah indexed tidak bisa dirubah data type nya Thank you Riky Andrian ---------------------------- Completely or not at all. ________________________________________ From: [email protected] [[email protected]] On Behalf Of Kahfi Heryandi Suradiradja [[email protected]] Sent: Tuesday, March 22, 2011 8:28 AM To: [email protected] Subject: Re: [indopb] Error sewaktu alter table saya kayaknya dulu pernah mengalami, coba di drop dulu index nya terus alter tablenya baru setelah itu create lagi indexnya. siapa tau sama problem solving nya --- On Mon, 21/3/11, Gunawan, PE (Peter) <[email protected]> wrote: From: Gunawan, PE (Peter) <[email protected]> Subject: [indopb] Error sewaktu alter table To: "IndoPB.Group" <[email protected]> Date: Monday, 21 March, 2011, 4:50 PM Dear All, Ada error sewaktu alter table sebuah kolom : mengubah tipe data dari number menjadi string sekaligus mengubah length nya (menambah). Database Syabase ASE 15: “Create index with sorted_data was aborted because of row out of order. Primary key of first out of order row is...” Regards, Peter Gunawan Rabobank International Indonesia ITSD Department Postal address: Jl. Tanah Abang II No.89 Jakarta 10150, Indonesia Telephone: (62)-(21) 3506969, 3500570 ext.2055 Email: [email protected]</mc/[email protected]> Website: www.rabobank.com<http://www.rabobank.com/> P Please consider the environment before printing this e-mail ________________________________ This email (including any attachments to it) is confidential, legally privileged, subject to copyright and is sent for the personal attention of the intended recipient only. If you have received this email in error, please advise us immediately and delete it. You are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Although we have taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the viruses in this email or attachments. We exclude any liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided in this email or its attachments, unless that information is subsequently confirmed in writing. If this email contains an offer, that should be considered as an invitation to treat. ________________________________ The information contained in this email including any files transmitted are confidential and intended solely for the use of the individual or entity to whom they are addressed. They may contain legally privileged information, and may not be disclosed to anyone else. If you are not the intended recipient(s), you are hereby notified that any distribution or copying of this e-mail message is strictly prohibited and please delete any copies from your system. In case any content of this e-mail message does not relate to the official business of the domain owner(company), it should be deemed and understood as neither given nor endorsed by the domain owner (company). Thank you. ------------------------------------ ----------------------------------------------- IndoPB - Indonesia PB User Group http://groups.yahoo.com/group/indopbYahoo! Groups Links ------------------------------------ ----------------------------------------------- IndoPB - Indonesia PB User Group http://groups.yahoo.com/group/indopbYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indopb/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
