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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top