oracle中如何造千万级的测试数据
--建表语句
CREATE
TABLE TEST_EXPORT
(
ID VARCHAR2(50) NOT NULL,
NAME VARCHAR2(50),
REMARK VARCHAR2(50),
PRIMARY KEY (ID)
)

--序列
CREATE SEQUENCE "SCOTT"."TEST_SEQ" MINVALUE 1 MAXVALUE 999999999 INCREMENT BY 1 START WITH 1 CACHE 2000 NOORDER NOCYCLE


最好是有效率点的 谢谢 Oracle
[解决办法]
弄个for循环
[解决办法]

引用:

--建表语句
CREATE
TABLE TEST_EXPORT
(
ID VARCHAR2(50) NOT NULL,
NAME VARCHAR2(50),
REMARK VARCHAR2(50),
PRIMARY KEY (ID)
)

--序列
CREATE SEQUENCE "SCOTT"."TEST_SEQ" MINVALUE 1 MAXVALUE 999999999 INCREMENT BY 1 START WITH 1 CACHE 2000 NOORDER NOCYCLE


最好是有效率点的 谢谢

 DROP TABLE TEST_EXPORT PURGE;
 CREATE TABLE TEST_EXPORT NOLOGGING PARALLEL 4
 AS
 SELECT LEVEL AS ID,
 LEVEL
[解决办法]
'NAME' AS NAME,
 LEVEL
[解决办法]
'REMARK' AS REMARK
 FROM DUAL CONNECT BY LEVEL<=10000000;

[解决办法]
并行度 PARALLEL设置为你的CPU核心数量,运行的时候会影响到其他的程序.

[解决办法]
然后

CREATE SEQUENCE "SCOTT"."TEST_SEQ" MINVALUE 10000000 MAXVALUE 999999999 INCREMENT BY 1 START WITH 1 CACHE 2000 NOORDER NOCYCLE

给表增加主键约束.
[解决办法]

[解决办法]
2楼的方法考虑的很全面了，关闭日志，并行，connect by自行循环