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.

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.

Answer / ravi

while adding data file first of all we have to check the
which table space having enough free space,in that table
space add the data file through BRTOOLS

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.

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

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

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

how to do system refresh?not the client copy but the-standard-system-refresh.

0 Answers   iGate,

Buffer monitoring?

2 Answers  

How you apply patches on java using JSPM?

1 Answers  

How to increase swap memory without doing any changes to Parameter value

2 Answers   IBM,

AS-IS & TO-BE process, who gets involved?

1 Answers  

What do you know about current kernel patch level?

3 Answers  

What is the difference between Central Instance & SID(system id)

2 Answers  

can u explain step by step procedure of DB REFRESH..Ravi

0 Answers  

how many max application server we created in company. last limitation pls tell me in figure?

7 Answers  

if there are 3 clients in quality(100,200,300) and only two clients in production(100,200) , how many clients will be there after system Refresh ?

3 Answers   IBM, L&T,

Explain what is sap ides?

0 Answers  

Client export/ import pre-requisite?

3 Answers