Increasing tablespace size
500237Apr 13 2006 — edited Apr 17 2006Hi All,
Plz help me in this problem,
I want to insert some 17k rows into a table in certain schema.
But after trying to do that,come to know that tablespace is full and needs to be extended.
But I done know exactly how to proceed with it.I am trying to find out the datafile and schema name in which that table exist.
But from dba_extents,got to know the datafile which is online.Now when I tried to add another 1000M file to that tablespace,its giving the error as disk space full so dont understand whether the probl is with tablespace or with disk.
Also is there any way to find out tablename,tablespace name and schema name in any dynamic view.
Can you help me in this matter...
Aashish S.