Tag Archive: Tablespace

Creating Tablespaces in ASM
  • 4
    Nov

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...

Read More
Creating Tablespaces in ASM
  • 6
    Ott

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...

Read More
Moving Audit Trail Table
  • 11
    Giu

Moving Audit Trail Table

Reading the previous article posted on June 3 about enabling auditing in an Oracle Database, I'd like to add some other useful information. Oracle stores all the audit results in the SYS.AUD$ table, as stated in the previous article. But...

Read More
Overview of an interesting bug
  • 28
    Mag

Overview of an interesting bug

 Often you may need to load data to the database under a different schema and different tablespace. With Oracle Data Pump all this is possible in a very simple way. Among the various options of the routine impdp you can...

Read More