Renaming tempfile in 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Renaming tempfile in 9i

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    8
    Could anyone tell me if tempfile could be renamed.

    I am confused because sts and otn says they could be renamed while ILT says - You cannot rename a tempfile(p235)

    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    how about try it yourself instead of read what book says

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I have done that several times like this:

    Assume that in 9i your default temporary tablespace is called TEMP and the tempfile is called '/u03/oradata1/temp01.dbf' so that TEMP is the default temporary tablespace for the database.

    1. CREATE TEMPORARY TABLESPACE temp2
    TEMPFILE '/u03/oradata1/temp02.dbf' size 5M
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

    2. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

    3. DROP TABLESPACE temp;

    4. CREATE TEMPORARY TABLESPACE temp
    TEMPFILE '/u03/oradata1/new_name.dbf' size 1024M
    AUTOEXTEND ON NEXT 256M MAXSIZE 4096M
    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

    5. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;

    6. DROP TABLESPACE temp2;

    Remove '/u03/oradata1/temp01.dbf' and '/u03/oradata1/temp02.dbf'
    from disk.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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