请教扩库问题

chenfeng825

IQ dbspace和ase的segment和oracle的dbspace是有差异的。
仔细看看那段create table (in字句的说明) 或者 in "SYSTEM"看看

hfvbc

这个语法是没有错误的啊．因为我用那个语法在其他的表空间里面没有出现类似的问题啊．

hfvbc

呵呵，希望你们能看看我的错误说明啊

hfvbc

我用语句:
CREATE TABLE "DBA"."Gfzkj" (
        "id" char(6) NOT NULL UNIQUE,
        "date" date NOT NULL,
        "value" double NOT NULL,
        PRIMARY KEY ( "id" )
) IN "GP";
建表的时候出错了,错误信息为:
could not execute statement.
ASA Error -1010036:MPX:invalid file_id.Single_node or writer server using a locate or bad fileID.

hfvbc

请问高手们,这个问题怎么解决啊?

chuxu

你确认在其他的dbspace上能使用create table in ‘dbspace'的语法？

chenfeng825

原帖由 chenfeng825 于 2008-4-15 14:00 发表
去掉in字句

IN clause

The IN clause specifies in which database file (dbspace) the table is to be created. You can specify SYSTEM with this clause to put either a permanent or temporary tabl ...

再次引用，仔细看看说明

IN clause

The IN clause specifies in which database file (dbspace) the table is to be created. You can specify SYSTEM with this clause to put either a permanent or temporary table in the Catalog Store. All other use of the IN clause is ignored. You cannot use this clause to place an IQ table in a particular dbspace. By default all permanent tables are placed in the main IQ Store, and all temporary tables are placed in the Temporary IQ Store. Global temporary tables can never be in the IQ Store.

hfvbc

原帖由 chenfeng825 于 2008-4-16 10:14 发表



再次引用，仔细看看说明

IN clause

The IN clause specifies in which database file (dbspace) the table is to be created. You can specify SYSTEM with this clause to put either a permanent ...

呵呵,你怎么不相信呢,以下是我在sybaseCentral里面在一个table上点右键复制的一个表:
CREATE TABLE "DBA"."Gfzkj" (
        "id" char(6) NOT NULL,
        "Hdate" date NOT NULL,
        "Hvalue" double NOT NULL,
        "Ldate" date NOT NULL,
        "Lvalue" double NOT NULL
) IN "IQ_SYSTEM_MAIN";