Recreate temp tablespace Oracle 10g


SQL> create temporary tablespace temp1 tempfile '/DATA/oradata/OCM/temp1.dbf' size 100M;
Tablespace created.
SQL> alter database default temporary tablespace temp1;
Database altered.
SQL> drop tablespace temp including contents and datafiles;
Tablespace dropped.
SQL> CREATE SMALLFILE TEMPORARY TABLESPACE TEMP
2 TEMPFILE '/DATA/oradata/OCM/temp01.dbf' SIZE 1000M
3 AUTOEXTEND ON NEXT 150M MAXSIZE 32767M
4 ,'/DATA/oradata/OCM/temp02.dbf' SIZE 1000M
5 AUTOEXTEND ON NEXT 150M MAXSIZE 32767M
6 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;
Tablespace created.
SQL> alter database default temporary tablespace temp;
Database altered.
SQL> drop tablespace temp1 including contents and datafiles;
Tablespace dropped.
SQL>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: