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

Which table contains the details related to Q defined in SPAM? Is there a way to revert back the Q defined? If yes, How?

0 Answers   IBM,

what are the prerequisite for before applying support packs? Shall I apply sap basis patch to all the system, like BW, ABAP, HR, etc.

3 Answers   Terrenos,

What is MySAP?

0 Answers   IBM,

How to find Expensive SQL Statements? How to solve?

3 Answers   IBM,

What is SAPCPE.EXE??

2 Answers   ABC, NTT Data,

Two background jobs triggered while transporting

2 Answers   Infosys, SAP Labs,

what is the use of S_TABU_DIS

1 Answers  

What are the prerequisites for adding a data file to a Table space?

7 Answers   IBM,

Basic configuration/ settings after installation of SAP Web AS in standalone SAP-CRM system for web client.

2 Answers   SAP Labs,

List some disadvantages of SAP.

5 Answers  

Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?

0 Answers  

What is you allocate disks to different areas in sap?

0 Answers