Create

How to drop and create a Temporary Tablespace

Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory (see SORT_AREA_SIZE initialization parameter), space will be allocated in a temporary tablespace for doing the sort operation. Other SQL operations that might require disk sorting are: CREATE INDEX, ANALYZE, Select DISTINCT, ORDER BY, GROUP BY, UNION, INTERSECT, MINUS, Sort-Merge joins, etc.

Creating Tablespaces in ASM

When ASM creates a datafile for a permanent tablespace (or a temporary file for a temporary tablespace), the datafile is set to auto-extensible with an unlimited maximum size and 100 MB default size. You can use the AUTOEXTEND clause to override this default extensibility and the SIZE clause to override the default size. ASM applies attributes to the datafile, as specified in the system default template for a datafile as shown in the table in “Managing Disk Group Templates”. You can also create and specify your own template. Files in a tablespace might be in both ASM files and non-ASM Read More

Creating Tablespaces in ASM

  When ASM creates a datafile for a permanent tablespace, the datafile is set to auto-extensible with an unlimited maximum size and 100 MB default size. You can use the AUTOEXTEND clause to override this default extensibility and the SIZE clause to override the default size. ASM applies attributes to the datafile, as specified in the system default template for a datafile as shown in the table in Managing disk group templates If there is a disk group named DATA, you can create a tablespace TBSLAVORO in that disk group with the following SQL statement: CREATE TABLESPACE TBSLAVORO DATAFILE ‘+DATA’; Read More

Create Oracle Database 12c

Below are described installation step of Oracle Database Database 12c on Oracle Enterprise Linux 6. New Pluggable Database Features is chosen below. Install_Oracle_database12c