Oracle Database Exadata Cloud Service by Brian Spendolini

Author:Brian Spendolini
Language: eng
Format: epub
Publisher: McGraw-Hill Education
Published: 2019-12-27T16:00:00+00:00

And commit the data:

SQL> commit;

This SQL will fill the column with a random date between January 1, 1945, and December 31, 2018.

We now have a table created from the census data in the .csv file we used SCP to place on the Exadata Database compute node. Though this table is large (30,000 rows), we need to make it much bigger. To do this, we’ll use some SQL to insert into this table from the rows that are current in the table. First, though, we need to turn off logging:

SQL> alter table big_census nologging;

This SQL includes the /*+ append */ optimizer hint. This hint tells the database to do a direct-path insert, which will improve performance with a large insert. It does this by bypassing the buffer cache and bypassing triggers, and it appends the data to the table rather than looking for free space within the existing table blocks. Now we’ll do the inserts:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.