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 IndonesiaITSD DepartmentPostal address: Jl. Tanah Abang II No.89 Jakarta 10150, IndonesiaTelephone: (62)-(21) 3506969, 3500570 ext.2055Email: [email protected]: 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.
