oracle数据库初始化注意事项

1.先添加表空间并授权

create tablespace TEST_TABLESPACE_D datafile 'D:\oracle\oracle_dat\test_data001.dbf'  size 1G autoextend on next 100M maxsize 10G;
create tablespace TEST_TABLESPACE_I datafile 'D:\oracle\oracle_dat\test_index001.dbf'  size 1G autoextend on next 100M maxsize 10G;
alter user TEST default tablespace TEST_TABLESPACE_D;

2.有自增序列与初始化数据的时候

#先创建序列
CREATE SEQUENCE "SEQUENCE_TB_CHANNEL" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 ORDER NOCACHE;
#再添加数据，使用[序列名称].NEXTVAL
INSERT INTO "TB_CHANNEL"("ID", "CHANNEL_NAME", "COMPANY", "PRINCIPAL", "PHONE", "CHANNEL_NUM", "STATUS", "REMARKS") VALUES (SEQUENCE_TB_CHANNEL.NEXTVAL, '阿里', '阿里巴巴', '阿里巴巴', NULL, NULL, '0', NULL);