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

Thread: adding datafile

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Unhappy

    Hello people,
    My tablespace is running out of space so I have decided to add nother datafile.
    My original datafile looks like this:
    /u04/0rac06/d_dtatfile/work.dbf

    After I have added another datafile e.g.
    /u04/0rac06/d_dtatfile/work2.dbf.

    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
    /u04/0rac06/d_dtatfile/work.dbf

    The reason why I am asking is that I want both datafiles to look like this:
    /u04/0rac06/d_dtatfile/work1.db
    /u04/0rac06/d_dtatfile/work2.dbf


    still learning,
    learning

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    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
    Posts
    295
    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