create table administratos_tab (SYSTEM_ID NUMBER (4) not null,CALLCENTER_ID NUMBER (4) not null,ADMINIATRATORS_ID VARCHAR(15) not null,
ADMINIATRATORS_NAME VARCHAR(30) not null,ADMINIATRATORS_PASSWORD Varchar2(20) Not Null,SETUP_DATE DATE not null,CREATOR_ID VARCHAR(15) not null);
为什么在执行时有下面的错误:
ORA-00959 tablespace 'string' does not exist ;
怎么创建表空间
多谢各位!!!
ADMINIATRATORS_NAME VARCHAR(30) not null,ADMINIATRATORS_PASSWORD Varchar2(20) Not Null,SETUP_DATE DATE not null,CREATOR_ID VARCHAR(15) not null);
为什么在执行时有下面的错误:
ORA-00959 tablespace 'string' does not exist ;
怎么创建表空间
多谢各位!!!
create table administratos_tab (SYSTEM_ID NUMBER (4) not null,
CALLCENTER_ID NUMBER (4) not null,
ADMINIATRATORS_ID VARCHAR(15) not null,
ADMINIATRATORS_NAME VARCHAR(30) not null,
ADMINIATRATORS_PASSWORD Varchar2(20) Not Null,
SETUP_DATE DATE not null,
CREATOR_ID VARCHAR(15) not null)tablespace TABLESPACE
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
select username,default_tablespace from dba_users;