DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 8i database re-create temporary tablespace datafile

  1. #1
    Join Date
    Oct 2006
    Posts
    1

    8i database re-create temporary tablespace datafile

    I am running a 8.1.7 database.
    I want to resize the datafile in my temporary tablespace.
    When I try to resize i get ORA-03297: file contains used date beyond requested resize value.

    I have only a single datafile.
    Can I drop and re-created temp datafile while users still on the system in 8.1.7

    The users have their own tablespace assigned but the temporary tablespace is given access as well as standard temp area.

    thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you create a new one, move all users to it - then when no-one is using the old one you can drop it.

    However, it will likely grow to the same size again so why bother changing it?

  3. #3
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Instead add a new file to the Temp tablespace ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width