Q

Moving temp tablespace and temp file in 10g

I have done some relocation jobs of data files on Oracle 8i before. But in Oracle 10g, how could you deal with the TEMP tablespace and its temp file?

This Content Component encountered an error
I have done some relocation jobs of data files on Oracle 8i before, just like you have described in the question "Moving Oracle from C to E drive." But, to Oracle 10g, how could you deal with the TEMP tablespace and its temp file? Thanks!
For the TEMP tablespace and its tempfile, I simply create a new temp tablespace in the new location. I then change the default temp tablespace with the ALTER DATABASE command. Once done, I drop the original temp tablespace.
This was first published in December 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close