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

Thread: adding datafile

  1. #1
    Join Date
    Nov 2000


    Hello people,
    My tablespace is running out of space so I have decided to add nother datafile.
    My original datafile looks like this:

    After I have added another datafile e.g.

    Is the first datafile going to look like
    /u04/0rac06/d_dtatfile/work1.dbf automaticaaly after I have added the second datafile or I have to manually change it to look like this /u04/0rac06/d_dtatfile/work1.dbf instead of this

    The reason why I am asking is that I want both datafiles to look like this:

    still learning,

  2. #2
    Join Date
    Jun 2000
    It won't automatically be named work1.dbf you would have to do that manually.

    alter tablespace work offline;
    host cp /u04/Ora06/d_dtafile/work.dbf /u04/Ora06/d_dtafile/work1.dbf
    alter database rename datafile '/u04/Ora06/d_dtafile/work.dbf' to '/u04/Ora06/d_dtafile/work1.dbf'
    alter tablespace work online;

    Once you're sure it's running you should be able to just remove work.dbf

  3. #3
    Join Date
    Jun 2000
    After you add more datafiles into a tablespace, your
    original data file names will NOT be changed automatically.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.