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!

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: