Index problem

[FSM]

Hi guys, my question is: I want to know if my index is full or my tablespace needs new storage. the message is "Unable to extend index owner.pk_name by 7 in tablespace indexname." what can i do? ( I just inherited these DB and im new in oracle)

Thank you guys

FSM

Ps. How can i check the size of my different objects (tablespaces indexes etc)

 

[jimbopalmer]

there are two similar errors, one means the tablespace is full the other means the Index is full, yours sounds as if the tablespace is full

alter tablespace indexname add datafile '/data01/oradata/PID/index02.dbf' size 2048M;

obviously the actual location and name of the new file will depend on the OS, and you will choose a size that makes sense for you. One Gotcha: at least in Oracle 7, K and M are the only sizes allowed so a 2 gig files would be expressed in M

the one that sounds as if the index is full says 'maximum extents reached' i believe. I tried to remain child-like, all I acheived was childish.

 

[SiDBA]

You probably want to install enterprise manager on your machine. This suite of tools makes it easy to manage tablespaces/datafiles. Your problem more than likely is that you've run out of extents in the tablespace. This is especially likely if the default extent size and PCTINCREASE are small. You can log on as system and check tablespace storage parameters with the following SQL:

"select * from dba_tablespaces"

The other cause of this problem may be that you've run out of file space. You predefine datafile sizes in oracle when you create new datafiles for a tablespace. If this is your problem, you can create a new file -- or you can set the current file to autoextend with the following (system user) sql command:

"alter database datafile '/somepath/somefile.dbf' autoextend on"

 

[FSM]

Thank you very much guys!!! these are the kind of obstacles that make you learn, I got to read all the posible problems and now it's working perfectly, thank you guys!!! one other thing, I think that my DB is a fragmented, what tips can you give for better performence??? the exp/imp utility?? what parameters should i use??? thank you again!!!

FSM