I am Loading data in Production, I am having this troible so many Times, can any one please let me know how can I resolve this.
I am inserting records in to table about 700,000 but get this error
ERROR at line 1:
ORA-01653: unable to extend table PMM.MEDIA_LOCATION_TRACKING by 2052 in tablespace PMM_DATA_01
This is Storage and Other parameters specifide for thai table.
TABLESPACE PMM_DATA_01 PCTFREE 10
STORAGE ( INITIAL 40960 NEXT 3874816 PCTINCREASE 50 ))
FREELISTS 1 FREELIST GROUPS 1 )
Please let me know how can I get rid of that Error... Very Urgent.
Check out for the extents for the table.
Try adding another datafile and let me know. 'Cos, I too had the same problem and this worked out for me
First check you have the free space availble in your tablespace. if
yes then change the storage parameter pctincrease 0.
if not add the datafile to the tablespace.
Otherwise please let me know.
i got some scripts i will send it to you.
Sun Certified Sys. Admin
oracle want add 1 extent of 2052 blocks
if blocksize is 4 k => 8M
8M are not disponible on the tablespace,
you can alter the size of next extent
alter table ... storage (next extents 2M) for example
you can see the biggest extent disponible on your tablespace
select max(bytes) from dba_free_space
where tablespace_name= ...
and adjust the next on consequence
it's preferable to fix the pctincrease at 0 and define the initial
extent at the good dimension and the next at 10% of the initial
and other solution after this is to add datafile to tablespace
i hope have respond to your problem
sorry for my english
if you want more information you can mail me monday
for this week is my mail
1- check the free space on hard disk
2-ALTER TABLESPACE "t_name" DEFAULT STORAGE (
MAXEXTENTS UNLIMITED );
2- ALTER TABLESPACE "t_name" ADD DATAFILE 'c:\tt.ora'
SIZE 100K AUTOEXTEND ON NEXT 100K;
you can also use this command to to expand your data files if u have space
sql> ALTER DATABASE DATAFILE 'D:\ORANT\DATABASE\test.ORA' AUTOEXTEND ON NEXT 5M MAXSIZE 500M;
Click Here to Expand Forum to Full Width