Tag Archives: tablespace

Increasing size of ASM-based bigfile tablespace

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

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

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