Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    2

    Unanswered: a simple question about datafile

    hi,all,I want to add another datafile to my database9i,size 500m,and the original datafile has free space up to now,will the data be saved to the new datafile itself when the free space of original datafile is used out?

    thank you.

  2. #2
    Join Date
    Sep 2002
    Location
    Austria
    Posts
    37

    Re: a simple question about datafile

    Originally posted by windboxdb
    hi,all,I want to add another datafile to my database9i,size 500m,and the original datafile has free space up to now,will the data be saved to the new datafile itself when the free space of original datafile is used out?

    thank you.
    you do not necessarily have do create a NEW datafile.
    you can also RESIZE the existing datafile - then you can be 100% sure, that it is used more efficiently.

    your command would be:

    alter database datafile "my-datafile" RESIZE 1000M;

Posting Permissions

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