OraFAQ Forum: Server Utilities » How to solve this problem?

Home » RDBMS Server » Server Utilities » How to solve this problem?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to solve this problem? [message #69004]

Fri, 12 October 2001 13:32

Simon
Messages: 60
Registered: December 1998

Member

Hey buddies,

I met a question about populating data into my Oracle database. I have checked the free space of my tablespace, and there are still a lot free space. But after I popuplate
several million records, all the following data are rejected. I don't know why. Are there any parameters that I should adjust? And where and how can change them to hold more data?

The error message from my Java Exception program is below:

java.sql.SQLException: ORA-01653: unable to extend table SYS.ARTICLE by 311072 i
n tablespace SYSTEM
ORA-27059: skgfrsz: could not reduce file size
Linux Error: 22: Invalid argument
Additional information: 1

Thank you very much. My checking data is below:

select name, bytes/1024/1024 "Size in MB"
from v$sgastat
where name='free memory';

NAME Size in MB
-------------------------- ----------
free memory 2.17551041
free memory .5859375
free memory 15.9804688
3 rows selected.

TABLESPACE_NAME FREE SPACE SUM(MBYTES)
------------------------------ ----------
DRSYS 15.8671875
INDX 19.9921875
RBS 86.9921875
SYSTEM 7713.17969
TEMP 219.984375
TOOLS 9.9921875
USERS 19.9921875
7 rows selected.

----------------------------------------------------------------------

Report message to a moderator

Re: How to solve this problem? [message #69005 is a reply to message #69004]

Sat, 13 October 2001 03:00

Suresh Baral
Messages: 11
Registered: October 2001

Junior Member

Hi,
In this case please see intial_extent,next_extent,extents,max_extent size of sys.article from dba_segments. See also auto extent on for that segment. Add more spaces to system tablespace by adding more datafiles. Also see more disk space should be available in your HDD. Increase the max_extent size also.

That's all. Good luck.

Suresh

----------------------------------------------------------------------

Report message to a moderator

Re: How to solve this problem? [message #69022 is a reply to message #69004]

Tue, 16 October 2001 20:53

ramesh giri .n
Messages: 3
Registered: May 2001

Junior Member

hi,

i think youre not granted the user tablespace for the that user that youre logged in,

means the default tablespace is a system ok.

do one thing

alter tablespace users add datafile '/orahome/users.dbf' size 500MB;
as per your requirement.
or resize the tablespace
alter database <database name> datafile 'orahome/users.dbf' resize 1GB;
!exp username/password file=db.dmp log=db.log
alter user <abc> default tablespace users;
!imp abc/password file=db.dmp full=y

regds
ramesh giri .n

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Re: OCP Exam Papers
Next Topic:	Import Tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 16 22:07:56 CDT 2025