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 should I set priority for Printing say like user, teamlead, project manager?

0 Answers   IBM,

what r errors u faced while appling patches

1 Answers  

What is the state of Processes once it is started?

5 Answers  

What are the types of tranports?

3 Answers  

Explain what is heterogenous system copy and homogenous system copy ?

0 Answers  

For example, I want to transfer 50GB of data from DEV to Quality. I am using client export and import method; can you tell me how many hours take for client export and import? And also How many hours take for remote client copy?

1 Answers   Terrenos,

what is the difference between logon group(tcode-smlg) and rfc group(tcode-sm59)?

6 Answers   FCI,

what is ora-00252 and ora-00272 error represents how can u prevent this error?how can u trouble shhot this error?

2 Answers   CSC,

During Client Copy from Production(400) to Development(500) Ztables data of PRD server not copied ?

1 Answers   ISPL,

what is the difference between killing a job with core and killing a job without core......pls

6 Answers   IBM,

The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?

0 Answers  

What is the command to see the list of TCodes ?

5 Answers