Well if you have free space to create a test db(or a test server), then you can do the tricks there first. And if everything goes well, then you can apply it to your production in one weekends(if not 24x7 system).
How huge is your db right now?
Printable View
Well if you have free space to create a test db(or a test server), then you can do the tricks there first. And if everything goes well, then you can apply it to your production in one weekends(if not 24x7 system).
How huge is your db right now?
Well i dont think the real DBA and the sys administartor of my comp would agree to that...
And the database
now i have a diff question:
178061312 rbs01.dbf
183502848 system01.dbf
197296128 temp01.dbf
is it normal to have such huge datafiles?
Hi ,
You can rename the table and create the table with the same name by specifying the STORAGE parameter, I mean INITIAL extent, NEXT extent size inside the STORAGE parameter. Then this may solve the problem evenif you are specifying a low PCTFREE value for that table.
Pl get back to me if you have any concerns.
Those are small, not huge assuming bytesQuote:
Originally posted by helpme
178061312 rbs01.dbf
183502848 system01.dbf
197296128 temp01.dbf
I think 175 MB of System Tablespace and is too big
isn't it?
Regards
Shruti
not really satyendu
this was the storage clause in my original table
INITIAL 51200
NEXT 51200
MINEXTENTS 1
MAXEXTENTS 2147483645
and this in the new dummy 1
INITIAL 1048576
NEXT 10485760
MINEXTENTS 1
MAXEXTENTS 2147483645
even the new 1 has chained row....
thanx
Sam
thats wat xactly 1 of my freind react as when i told him bout my datafile size.
Is it really that huge?
175 is not that big, depending on what options you have installed and specially on a production database
Hi!!
But I think I never had System tablespace more than some 50 MB with all the options offered by DBCA.
I'm reffering to 8i. I think most of the tablespace might be fragmented that's reson for such huge size.
Regards
Shruti
Hi Shruti,Quote:
Originally posted by ShrutiM
Hi!!
But I think I never had System tablespace more than some 50 MB with all the options offered by DBCA.
I'm reffering to 8i. I think most of the tablespace might be fragmented that's reson for such huge size.
Regards
Shruti
If you install all the options offered by Oracle 8i like Advanced Replication, Spatial, Intermedia Text ... you must be sure that your System Tablespace will be over 300 MB :-)
Regards
Angel