oracle 10g SYSAUX tablespace

The SYSAUX(System Auxiliary) tablespace is a new feature of Oracle 10g database,before 10g release,there wasn’t this tablespace.After you created your database via DBCA(Database Configuration Assistant) tool,the SYSAUX tablespace was created for you automatically.
But what’s the mainly function of that tablespace? Why Oracle present the SYSAUX tablespace? Does it bring some benefit for the database or [...]

Categories: Experiments, Oracle, Tablespace  |   Tags: Oracle  |  2 Comments »

Managing Oracle Tablespaces and Data Files

A collection of 19 FAQs on creating and managing tablespaces and data files. Clear answers are provided with tutorial exercises on creating and dropping tablespaces; listing available tablespaces; creating and dropping data files; setting tablespaces and data files offline; removing corrupted data files. Topics included in this FAQ are:

What Is an Oracle Tablespace?
What Is an [...]

Categories: Oracle, Tablespace  |   Tags: Oracle  |  5 Comments »