| Author |
sa_migrate create index problem (more than 8 index per table)
|
|
| Timrek 2006-02-28, 8:34 pm |
| Is anybody have problem creating index while migrating a
consolidated database to a ASA database. I'm having problems
: with tables having more than 8 index. Under 6 index per
table seems to work fine. The procedure sa_migrate seems to
have problem with more than 8 index/table.
| |
| Breck Carter 2006-02-28, 8:34 pm |
| What version of ASA?
What kind of database is being migrated?
What exactly is the symptom or error message?
Breck
On 27 Feb 2006 12:02:48 -0800, Timrek wrote:
>Is anybody have problem creating index while migrating a
>consolidated database to a ASA database. I'm having problems
>: with tables having more than 8 index. Under 6 index per
>table seems to work fine. The procedure sa_migrate seems to
>have problem with more than 8 index/table.
--
breck.carter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/ SQL_Anyw...pers_Guide.html
| |
| David Fishburn 2006-02-28, 8:34 pm |
| Timrek wrote in news:44034b74.5dc7.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:
T> Is anybody have problem creating index while migrating a
T> consolidated database to a ASA database. I'm having problems
T>: with tables having more than 8 index. Under 6 index per
T> table seems to work fine. The procedure sa_migrate seems to
T> have problem with more than 8 index/table.
As Breck pointed out:
Please ALWAYS include version and MORE importantly BUILD number
with EACH post (dbeng9 -v).
Also show us:
1. The create table statement
2. Schema for the 8 indicies
3. What source the database is (ie Oracle and version info).
--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.ianywhere.com/developer
CaseXpress - to report bugs
http://casexpress.sybase.com
CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
|
|
|
|