bypassing temp tablespace while bringing the database

[soans]

Is there a way to bring the database up without the temporary tablespace by specifying some initialization parameters.

 

[karluk]

Is there any reason you can't just take the temporary tablespace offline after bringing up the database? Something like

alter tablespace temp offline;

 

[soans]

The temp tablespace was using all the volume in the diskspace which included the system tablespace. So the physical temp file was deleted. There was not enough disk space to created another temp file,drop the old one and bring back the new one back up

 

[karluk]

I found note 250064.995 on Metalink, which concerns someone with a very similar problem to yours. He dropped his temporary tablespace with the following commands, after creating a new temporary tablespace.

startup mount
alter database datafile x offline drop;
alter database open;
alter tablespace temp offline immediate;
drop tablespace temp;

If this works, you should then create a new temp ts to replace the one you just dropped.

 

[soans]

It worked. Thanks. It took a while the drop the datafile (about 7GB) using alter database command.