Oracle when was a table created

You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.

Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.

In this case it is better to allocate a second temporary tablespace with a smaller extent size. The following two statements create a temporary tablespace with a 64 KB extent size, and then a new temporary table in that tablespace.

Unlike permanent tables, temporary tables and their indexes do not automatically allocate a segment when they are created. If you rollback a transaction, the data you entered is lost, although the table definition persists. A transaction-specific temporary table allows only one transaction at a time. If there are several autonomous transactions in a single transaction scope, each autonomous transaction can use the table only as soon as the previous one commits.

Because the data in a temporary table is, by definition, temporary, backup and recovery of temporary table data is not available in the event of a system failure. To prepare for such a failure, you should develop alternative methods for preserving temporary table data.

Oracle Database can parallelize both parts of the statement. At least one of the tables specified in the query requires either a full table scan or an index range scan spanning multiple partitions. Any subsequent DML or queries on the table, for which parallelization is possible, will attempt to use parallel execution. The following simple statement parallelizes the creation of a table and stores the result in a compressed format, using table compression:.

Oracle Database Data Warehousing Guide for a detailed discussion about using parallel execution. The following simple statement parallelizes the creation of a table and stores the result in a compressed format, using table compression:. Skip Headers. Creating a Temporary Table Temporary tables are useful in applications where a result set is to be buffered temporarily persisted , perhaps because it is constructed by running multiple DML operations.

For example, consider the following: A Web-based airlines reservations application allows a customer to create several optional itineraries. A session becomes bound to the temporary table with a transactions first insert into the table. The binding goes away at the end of the transaction.

The database truncates the table delete all rows after each commit. A session gets bound to the temporary table with the first insert into the table in the session. The database truncates the table when you terminate the session.

See Also: "Temporary Tablespaces". All rights reserved. Book List. Master Index. Contact Us. This creates a temporary table that is transaction specific.