What are the prerequisites for adding a data file to a
Table space?
Answers were Sorted based on User's Feedback
Answer / suresh
Hi 123,
Oracle database consists one or more logical units of
storage called tablespaces, Each tablesapce consists one or
more file which are nothing but called data fiel, these are
the physical structure that confirm to the operating system
on which oracle is running.
Additional information added to the above would be
appreciated.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / srikanth
Pre-requisite is that we need to have the space in the
database first to extend the tablespace. If you have it
then u can extend it by adding a datafile.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rout
If u find a tablespace is filed with more than " 80% ",u
need to add datafile to table space.Otherwise it'ii
slowdown the system.
Is This Answer Correct ? | 7 Yes | 4 No |
Answer / renjith remanan
HI,
For extending the Tble Space, just Check the Fre Space in
OS level. Thats all.
Its enough to increase the table space, when it gets filled
more than 90%.
Renjith Remanan
Collabera/IBM
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / eswar
if the data file space in more than 90% then only u need to
add table space .To add table space we need free space in
the disk
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / 123
Are u sure "Mr Eswar " is it more than 90% ,definitely
not.Your database will slowdown if tablespace is filled
with more htan 90%.And the second thing what is a datafile
Is This Answer Correct ? | 0 Yes | 5 No |
what is the use of tcode pfud?what is it's advantage?
how do u relese chage request? is it possible to relese change request without relesing task?explain step by step
What are the activities you done in PI?
what is the function of garbage collector... can any one explain
how to build index in oracle? how to chk oracle up or not in sql?
In Hardware sizing what is user based sizing? and what is throughput sizing??
If client copy is stopped in middle, what happens if you want to start it again?
If java is down how you will do trouble shooting?
How the system log analysis will work(sm21),how the logs are sended,can anyone explain the behind process.
EWA configuration?
1 Answers HCL, Wipro, Yash Technologies,
Explain Post Installation Activities??
How you connect ECC to EP?