Adding Data Files automatically
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Adding Data Files automatically

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Hi!
    Is there any method of adding a new datafile to a tablespace when a existing datafile is full? I know there is a mehtod to auto incrementing or resizing the Datafiles, but the problem is very large file size can pose a problem at OS level.

    Thanks in Advance
    There Nothing You cannot Do, The problem is HOW.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you would have to write your own script

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Not AFAIK, there is no Oracle provided method. This is where the "A" in DBA comes from.

    My suggestion would be setup some monitoring scripts to tell you when you are almost full on a data file and then send yourself an email every morning indicating which tablespaces may be running out. If you want to get fancy, when your script recognizes you need a new datafile, you can automatically add it to your tablespace via some code.

    Personally, I like the human intervention so I can alleviate any problem before it gets out of hand, but I'm also AR...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    What will be the Triggering Event for the specific script. Will the script be a stored procedure or Shell Script?
    There Nothing You cannot Do, The problem is HOW.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by sudip
    What will be the Triggering Event for the specific script.

    Depends. Where would you add another data file?


    Will the script be a stored procedure or Shell Script?
    Yes. (you could do it either way)
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Feb 2001
    Posts
    389
    Not until u migrate to 9i, which has this feature.

    Till 8i, what u can do is , create a number of datafiles of minimum size say 10MB and set autoextend.
    And setup some warning procedure when u r left with last two datafiles .

  7. #7
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Is there a feature of automatically adding datafiles to a tablespace? Thats Cool.
    There Nothing You cannot Do, The problem is HOW.

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by sudip
    Is there a feature of automatically adding datafiles to a tablespace? Thats Cool.
    No, there is no such feature....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    what a danger, adding files automatically. itīs only good ONLY if you can drop a datafile from a tablespace which I have my doubts even in 9i

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    what a danger, adding files automatically. itīs only good ONLY if you can drop a datafile from a tablespace which I have my doubts even in 9i
    You are right, it is not possible in 9i.


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