How to add Dummy data into table
Reading time: < 1 minute
SQL>create table dev as select rownum num from dual connect by rownum <= 1000000;
Check the size of table after its creating using following SQL.
col segment_name format a20
select segment_name
,AAAAA bytes "SIZE_BYTES"
,AAAAA ceil(bytes / 1024 / 1024) "SIZE_MB"
fromAA dba_segments
whereA segment_name like 'DEV'
/
SEGMENT_NAMEAAAAAAAA SIZE_BYTESAAA SIZE_MB
-------------------- ---------- ----------
DEVAAAAAAAAAAAAAAAAAAA 12582912AAAAAAAA 12
