| Why can't I import more data into my Oracle database? [message #68998] |
Fri, 12 October 2001 06:21  |
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? 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 SUM(BYTES/
------------------------------ ----------
DRSYS 15.8671875
INDX 19.9921875
RBS 86.9921875
SYSTEM 7713.17969
TEMP 219.984375
TOOLS 9.9921875
USERS 19.9921875
7 rows selected.
----------------------------------------------------------------------
|
|
|
|
|
|
| Re: Why can't I import more data into my Oracle database? [message #69003 is a reply to message #68998] |
Fri, 12 October 2001 10:58  |
oraboy
Messages: 97
Registered: October 2001
|
Member |
|
|
Seems like you are trying to insert rows into a table which has already reached its max.
The reason what I think is..
the tablespace for the schema (where u import) is not sufficient enuf to hold your data.
Increase the tablespace and rerun fr import again.
oraboy
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
