Generate load on HR schema in Oracle 19c
Dear all,
I am trying to generate some load on HR schema tables to test a particular scenario in Oracle 19c. So I have used below - insert statement to have at least 7GB of size for one table and like this I have 10 tables and total size approx 70GB-
But now I wanted to test it aggressively and need at least 1TB of data in multiple tables. Could anyone please advise what is the best approach to make 1TB sample data in HR schema?
SET AUTOCOMMIT 50000 BEGIN FOR i IN 207..90000000 LOOP INSERT INTO employees_copy (employee_id, first_name, last_name, email, hire_date, job_id, salary) VALUES (i, 'employee#'||i,'temp_emp','abc@xmail.com',sysdate,'IT_PROG',1000); END LOOP; END; /