Temporary Table Redo- Tables and Constraints
No redo data are generated for changes to blocks of a global temporary table. However, rollback (undo) data is generated...
Viewing Index Metadata
Removing Data from a Table- Tables and Constraints
You can use either the DELETE statement or the TRUNCATE statement to remove records from a table. A DELETE statement...
Displaying Table DDL- Tables and Constraints
Sometimes, a table definition is not documented at the time of creation, maybe from a DBA or developer or directly...
Enabling DDL Logging- Tables and Constraints
Oracle allows you to enable the logging of DDL statements to a log file. This type of logging is switched...
Default Parallel SQL Execution- Tables and Constraints
If you work with large tables, you may want to consider creating your tables as PARALLEL. This instructs Oracle to...