Tag Archives: tablespace

Increasing size of ASM-based bigfile tablespace

Posted on May 27, 2013 by SoCRaT

Firstly few commands to get you up & running: – Get names of tablespaces: “select name from v$tablespace;” – Get names of disk groups: “select name from v$asm_diskgroup;” – Get names of data files: “select name from v$datafile;” In my … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Temporary Tablespace in Oracle 10g

Posted on October 31, 2010 by Osama Magdy

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, space will be allocated in a temporary … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment

How to add a new data file to Oracle Tablespace using sqlplus

Posted on December 14, 2009 by SoCRaT

First login as the “oracle” user, and issue the command “sqlplus “/ as sysdba”” (I am assuming that you already have configured the  PATH environment variable correctly) and then type the following:   alter tablespace tablespace_name  add datafile ‘/oracle/data/file1.dbf’ size … Continue reading →

Tagged , , | Leave a comment