使用SQL语句进行创建.
1.创建表空间
-- 公共模块表空间 create tablespace cctc_coreloggingdatafile '/ORACLE/PRODUCT/10.2.0/ORADATA/cctchdcq/cctc_core.dbf'size 100m autoextend on next 10mextent management localsegment space management auto /-- 业务表空间 create tablespace cctc_operationloggingdatafile '/ORACLE/PRODUCT/10.2.0/ORADATA/cctchdcq/cctc_operation.dbf'size 100mautoextend on next 10mextent management localsegment space management auto /
2.创建用户并分配权限
-- Create the user create user HDCQ default tablespace CCTC_CORE--默认表空间 temporary tablespace TEMP profile DEFAULT quota unlimited on cctc_core--设定用户的表空间 quota unlimited on cctc_operation;--设定用户的表空间 -- Grant/Revoke role privileges 设定用户权限 grant connect to HDCQ with admin option; grant dba to HDCQ with admin option; grant resource to HDCQ with admin option; -- Grant/Revoke system privileges 表空间的系统权限 grant unlimited tablespace to HDCQ with admin option;
3.创建表
create table t_organization (-- 主键org_pk number(10,0)not null,-- 父主键
father_org_pknumber(10,0) default 0,-- 组织机构名称
org_name varchar2(100) not null,-- 创建时间
create_time varchar2(50) default to_char(sysdate,'yyyy-MM-dd HH:mm:ss') not null,constraint pk_t_organization primary key (org_pk)) tablespace cctc_core/create sequence seq_organizationstart with 140increment by 1maxvalue 9999999999minvalue 1cycle/ -- ============================================= --用途:创建客户来电表 -- 表名:t_customer -- ============================================= create table t_customer ( --主键 customer_pk raw(16) not null, --客户名称 customer_name varchar2(200) not null, --客户电话 customer_phone varchar2(100) not null, --创建人 create_user_pk int not null, --创建时间 create_time varchar2(50) default to_char(sysdate,'yyyy-MM-dd HH:mm:ss') not null,constraint pk_t_customer primary key (customer_pk) )tablespace cctc_operation/