-
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.
-
you would have to write your own script
-
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
-
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.
-
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
-
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 .
-
Is there a feature of automatically adding datafiles to a tablespace? Thats Cool.
There Nothing You cannot Do, The problem is HOW.
-
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?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|