I want to test explain query plan in Oracle 9i. For that I want to create very large tables (2 or more tables). Either 1 table containing 1 million records or 2 to 3 tables where join will contain more than a million records. Kindly help me with such tables.

Thanks.