Renaming a Column- Tables and Constraints
There are a couple of reasons to rename a column. Sometimes, requirements change, and you may want to modify the...
Parallelizing Index Creation
Renaming a Table- Tables and Constraints
There are a couple of reasons for renaming a table:• Make the table conform to standards• Better determine whether the...
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...
Avoiding Redo Creation- Tables and Constraints
When you are creating a table, you have the option of specifying the NOLOGGING clause. The NOLOGGING feature can greatly...
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...