sybase ASE-12_5建表问题 - ORACLE等数据库 - LoveUnix -- 最强AIX小机技术论坛,UNIX,Linux,存储,数据库,中间件,开发,管理 -- 蓝色的IBM技术天堂 --bbs.LoveUnix.net

LU新生

UID 19344
精华 0
积分 16
帖子 30
活跃指数 6
LU金币 2029 个
LU金条 0 个
阅读权限 10
注册 2004-4-27

发表于 2006-12-20 09:22 资料个人空间短消息加为好友

sybase ASE-12_5建表问题

在建表后无法倒入数据，用sp_help查看发现有以下错误          1> sp_help sys_exception
2> go
Name                         Owner
      Object_type
------------------------------ ------------------------------
      --------------------------------
sys_exception                dbo
      user table

(1 row affected)
Data_located_on_segment       When_created
------------------------------ --------------------------
default                            Dec 20 2006  9:27AM
Column_name    Type          Length    Prec Scale Nulls Default_name
      Rule_name    Access_Rule_name             Identity
--------------- --------------- ----------- ---- ----- ----- ---------------
      --------------- ------------------------------ --------
exceptionCode char                   1 NULL  NULL    0 NULL
      NULL          NULL                               0
personName    varchar                1 NULL  NULL    1 NULL
      NULL          NULL                               0
exceptionDate datetime                8 NULL  NULL    1 NULL
      NULL          NULL                               0
modulePrompt varchar                1 NULL  NULL    1 NULL
      NULL          NULL                               0
exceptionMsg text                   16 NULL  NULL    1 NULL
      NULL          NULL                               0
index_name          index_description
      index_keys
      index_max_rows_per_page index_fillfactor index_reservepagegap
      index_created
-------------------- --------------------------------------------------------
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      ----------------------- ---------------- --------------------
      -------------------
PK_SYS_EXCEPTION    clustered, unique located on default
      exceptionCode
                           0             0                   0
      Dec 20 2006  9:27AM

(1 row affected)
No defined keys for this object.
Object is not partitioned.
Lock scheme Allpages
The attribute 'exp_row_size' is not applicable to tables with allpages lock
scheme.
The attribute 'concurrency_opt_threshold' is not applicable to tables with
allpages lock scheme.

exp_row_size reservepagegap fillfactor max_rows_per_page identity_gap
------------ -------------- ---------- ----------------- ------------
         0             0       0                0          0

(1 row affected)
concurrency_opt_threshold optimistic_index_lock
------------------------- ---------------------
                     0                   0
(return status = 0)
1>
建表脚本：    print 'sys_exception'
SETUSER 'dbo'
go

drop table dbo.sys_exception
go
create table dbo.sys_exception (
exceptionCode char not null,
personName  varchar null,
exceptionDate datetime null,
modulePrompt varchar null,
exceptionMsg text null,
constraint PK_SYS_EXCEPTION PRIMARY KEY  CLUSTERED ( exceptionCode )
)
on 'default'
go请问如何处理？

[ 本帖最后由 xgxhws 于 2006-12-20 09:42 编辑 ]