1、连接manager工具,启动该工具
[root@DCATEST tool]# cd /dm7/tool
[root@DCATEST tool]# ./manager
2、登录到实例服务
3、新建表空间
配置表空间
4、新建用户(一定要选好对应的表空间)
5、新建表
create table “TEST”.“EMPLOYEES”
(
“EMPLOYEE_ID” DEC(6, 0) not null ,
“EMPLOYEE_NAME” VARCHAR(20) not null ,
“EMAIL” VARCHAR(25) not null ,
“PHONE_NUMBER” VARCHAR(20),
“HIRE_DATE” DATETIME(6) not null ,
“JOB_ID” VARCHAR(10) not null ,
“SALARY” DEC(8, 2),
“COMMISSION_PCT” DEC(2, 2),
“MANAGER_ID” DEC(6, 0),
“DEPARTMENT_ID” DEC(4, 0),
primary key(“EMPLOYEE_ID”)
)
storage(initial 1, next 1, minextents 1, fillfactor 0, on “TBS”);
create table “TEST”.“DEPARTMENTS”
(
“DEPARTMENT_ID” DEC(4, 0) not null ,
“DEPARTMENT_NAME” VARCHAR(30) not null ,
“MANAGER_ID” DEC(6, 0),
“LOCATION_ID” DEC(4, 0),
primary key(“DEPARTMENT_ID”)
)
storage(initial 1, next 1, minextents 1, fillfactor 0, on “TBS”);
6、创建外键