1、 启停操作文档
1、1 目录节点启停
2、 数据库操作
2、1 创建用户并授权
（一）创建用户
登录目录节点：
[oracle@testdb1 ~]$ sqlplus / as sysdba
SQL> alter session enable shard ddl;
create user tpce identified by tpce;
登录分片节点：
SQL> select USERNAME from dba_users where username =’TPCE’;
USERNAME
-——————————————————————————-
TPCE
备注：用户自动建立
（二）授权
SQL> create user tpce identified by tpce;
SQL> grant all privileges to tpce;
SQL> grant gsmadmin_role to tpce;
SQL> grant select_catalog_role to tpce;
SQL> grant connect, resource to tpce;
SQL>grant dba to tpce;
SQL> grant execute on dbms_crypto to tpce;
2、2 创建表空间
（一）创建表空间集
SQL> create tablespace set tbs_tpce using template(datafile size 100m autoextend on next 100m maxsize 16g);
（二）创建单表空间
SQL> create tablespace test1 datafile size 100m autoextend on next 100m maxsize 16g;
（三）表空间验证
登录分区节点：
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
-—————————–
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
TBS_TPCE
C001TBS_TPCE
C002TBS_TPCE
C003TBS_TPCE
C004TBS_TPCE
C005TBS_TPCE
C006TBS_TPCE
TEST1
2、3 创建表
（一） 创建分片表
SQL> connect tpce/tpce
Connected.
SQL> CREATE SHARDED TABLE Customers
2 (
3 CustId VARCHAR2(60) NOT NULL,
4 FirstName VARCHAR2(60),
5 LastName VARCHAR2(60),
6 Class VARCHAR2(10),
7 Geo VARCHAR2(8),
8 CustProfile VARCHAR2(4000),
9 Passwd RAW(60),
10 CONSTRAINT pk_customers PRIMARY KEY (CustId),
11 CONSTRAINT json_customers CHECK (CustProfile IS JSON)
12 ) TABLESPACE SET tbs_tpce
13 PARTITION BY CONSISTENT HASH (CustId) PARTITIONS AUTO;
Table created.
SQL> CREATE SHARDED TABLE Orders
2 (
3 OrderId INTEGER NOT NULL,
4 CustId VARCHAR2(60) NOT NULL,
5 OrderDate TIMESTAMP NOT NULL,
6 SumTotal NUMBER(19,4),
7 Status CHAR(4),
8 CONSTRAINT pk_orders PRIMARY KEY (CustId, OrderId),
9 CONSTRAINT fk_orders_parent FOREIGN KEY (CustId)
10 REFERENCES Customers ON DELETE CASCADE
11 ) PARTITION BY REFERENCE (fk_orders_parent);
Table created.
SQL> CREATE SHARDED TABLE LineItems
2 (
3 OrderId INTEGER NOT NULL,
4 CustId VARCHAR2(60) NOT NULL,
5 ProductId INTEGER NOT NULL,
6 Price NUMBER(19,4),
7 Qty NUMBER,
8 CONSTRAINT pk_items PRIMARY KEY (CustId, OrderId, ProductId),
9 CONSTRAINT fk_items_parent FOREIGN KEY (CustId, OrderId)
10 REFERENCES Orders ON DELETE CASCADE
11 ) PARTITION BY REFERENCE (fk_items_parent);
（二） 创建复制表
SQL> CREATE DUPLICATED TABLE Products
2 (
3 ProductId INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
4 Name VARCHAR2(128),
5 DescrUri VARCHAR2(128),
6 LastPrice NUMBER(19,4)
7 ) TABLESPACE test1 ;
（三） 验证
SQL> select TABLE_NAME,TABLESPACE_NAME from user_tables;
TABLE_NAME TABLESPACE_NAME
PRODUCTS TEST1
CUSTOMERS
ORDERS
LINEITEMS