Home » RDBMS Server » Server Administration » How to reduce SYSTEM tablespace???
How to reduce SYSTEM tablespace??? [message #56118] Thu, 06 March 2003 21:11
YIM
Messages: 1
Registered: March 2003
Junior Member
I created A user but forgot to assign temporary tablespace. Yesterday A user did huge data copying job.. that cause this problem...I changed A user's tablespace...but I don't know how to resize
I tried "coalesce tablespace and ALTER DATABASE DATAFILE '/oradata1/SYSTEM/system01.dbf' RESIZE 200M;
but it didn't work ..I always got ORA-3297 error message.

Please How can slove this big problem....

Thank you for reading...

Report message to a moderator

Previous Topic: how to?
Next Topic: There was an error during loading library : areasQueries
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:52:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.