网上找了一个sql可以大批量生成测试数据:
create table myTestTable as select rownum as id, to_char(sysdate + rownum/24/3600, 'yyyy-mm-dd hh24:mi:ss') as inc_datetime, trunc(dbms_random.value(0, 100)) as random_id, dbms_random.string('x', 20) random_string from dual connect by level <= 1200000;
执行时报错:
ORA-01536: 超出表空间 'USERS' 的空间限额
增加表空间:
alter user liu quota unlimited on users;
再执行时又报错:
ORA-30009: CONNECT BY 操作内存不足
or
ORA-30009: Not enough memory for CONNECT BY operation
继续阅读oracle生成测试数据