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

Thread: Resize a datafile.

  1. #1
    Join Date
    Aug 2002
    Posts
    13

    Resize a datafile.

    Hi all,

    Therz a problem while resizing a datafile.
    Getting the error ORA-03296: cannot resize datafile - file and datafile not found. but the datafile exists in the specified path.

    What could be the reason for this?

    Thanks in advance,
    dsr.

  2. #2
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49
    Hi,

    For teh resizing, are u incresaing or decresaing? If decreasing, the talespace can only resize only to the amount of data block not beign used. SO if your tablepsace is very full. you may not be able to resize.

    To increase. maybe you can check the exact pathing of the datafile and whether there is enough hardisk space to increase.
    Regards
    CF

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Make sure that the file name, extention and path you are typing is correct and included in single quotes.

    Sanjay

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    select file_name , status from dba_data_files ;

    if u are trying to decrease the datafile size below high water mark it is not possible . however u should able to increase the size .
    siva prakash
    DBA

  5. #5
    Join Date
    Aug 2002
    Posts
    13
    Hi,

    I carried out the defragmentation procedure and tried to resize the datafile, it worked.

    Is it because there was not an extent large enough to hold the resized data file that the resizing process failed earlier?

    Thanks all for ur reponses.
    dsr.

  6. #6
    Join Date
    Jul 2000
    Posts
    119
    I don't know what defragmentation procedure you carried out, but the error message you posted earlier sure was wrong. It said the file is not existing. If the datafile you need to shrink has occupied any blocks beyond the point you specified, it will specifically say that!
    OCP 8.0, 8i, 9i

  7. #7
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Hi

    it is interesting.. Well.. One possibility..

    While you created the datafile the file name may include a space. So oracle can recognize the file, but while you type it may not recognize. First check wether there is a space with the file name.

    select '"'||file_name||'"' from dba_data_files;

    check in the output there is a space allocated in the file name.


    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  8. #8
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    Instead of using alter database datafile 'datafile name' resize , use the file_id. If the problem is the space between datafile name, you won't get problem this way.

    select file_id, file_name from dba_data_files;

    alter database datafile resize


    F

  9. #9
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    ops...

    alter database datafile id resize size

  10. #10
    Join Date
    Aug 2002
    Posts
    13
    Hi,

    The error message i gave is correct and there was no space in the file name...ie to tell that the path of the datafile i specified was correct.

    Resizing(to increase the size) which was not possible before defragmentation was possible after that. Am new to dba so can anyone conclude something from the above.


    Thanx all for ur responses,
    dsr.

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