用powerDesigner设计了一个数据模型,该数据模型中某个数据实体ACCT属于一个域USER_ACCT,然后用powerDesigner自动产生sql脚本,用oracle执行下列脚本语句
create table USER_ACCT.ACCT (
ACCT_ID NUMBER(12) not null,
CUST_ID NUMBER(12) not null,
ACCT_NAME VARCHAR2(50) not null,
ADDRESS_ID NUMBER(9) not null,
STATE VARCHAR2(3)
constraint CKC_STATE_ACCT check (STATE is null or ( STATE in ('10A','10X','10H') )),
STATE_DATE DATE not null,
constraint PK_ACCT primary key (ACCT_ID)
)时产生Error on line 31
/*==============================================================*/
/* Table: ACORA-01918: 用户'USER_ACCT'不存在请问高手怎么解决啊
create table USER_ACCT.ACCT (
ACCT_ID NUMBER(12) not null,
CUST_ID NUMBER(12) not null,
ACCT_NAME VARCHAR2(50) not null,
ADDRESS_ID NUMBER(9) not null,
STATE VARCHAR2(3)
constraint CKC_STATE_ACCT check (STATE is null or ( STATE in ('10A','10X','10H') )),
STATE_DATE DATE not null,
constraint PK_ACCT primary key (ACCT_ID)
)时产生Error on line 31
/*==============================================================*/
/* Table: ACORA-01918: 用户'USER_ACCT'不存在请问高手怎么解决啊
/create table USER_ACCT.ACCT (
ACCT_ID NUMBER(12) not null,
CUST_ID NUMBER(12) not null,
ACCT_NAME VARCHAR2(50) not null,
ADDRESS_ID NUMBER(9) not null,
STATE VARCHAR2(3)
constraint CKC_STATE_ACCT check (STATE is null or ( STATE in ('10A','10X','10H') )),
STATE_DATE DATE not null,
constraint PK_ACCT primary key (ACCT_ID)
)
/建立了,但仍有错
Error on line 15
create table USER_ACCT.ACCT (
ACCT_ID NUMBER(12) ORA-01950: 表空间'SYSTEM'中无权限
grant connect,resource to USER_ACCT;
conn USER_ACCT/123然后执行你创建表的语句
1.域USER_ACCT的概念是什么呢,是对应数据库中的一个用户么?2.创建应用所使用的表的时候不应该在系统表空间system里面创建的,这样将会影响以后的整体性能,还会让数据库的表空间变得很混乱,建议新建一个用户表空间,然后再创建对应的表...
create table USER_ACCT.ACCT 这个代码,但是没生成USER_ACCT