Oracle DBA and beyond; these are practical tips for day to day DBA operation and maintenance; a place where you would come to look for a quick fix for a burning situation. I hope that by sharing all these, we all will become better in what we do. And on the way, I hope to save you some sweat :-)
Friday, 8 February 2019
How to create fast a table with 1 million rows
create table test1
as
select rownum rn, mod(rownum,1000) mod1 , mod(rownum,90) mod2
from dual connect by level <=1000000;
No comments:
Post a Comment