query required [message #473191] |
Thu, 26 August 2010 11:04  |
sathik
Messages: 196 Registered: August 2009 Location: INDIA
|
Senior Member |
|
|
When I import the table, i am getting the below error.
Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and WE8ISO8859P1 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . importing table "T4159"
IMP-00058: ORACLE error 1562 encountered
ORA-01562: failed to extend rollback segment number 2
ORA-01650: unable to extend rollback segment RBSA_03 by 16 in tablespace RBS_A
I know this error occurs because of no space in the rollback segment. So I need to alter the rollback segment size.
Since I am new to oracle 8i, can u give me the query to do the below activity?
1. alter rollback segment size to greater size.
2. add new rollback segment.
[Updated on: Thu, 26 August 2010 11:08] Report message to a moderator
|
|
|
|
|
Re: query required [message #473199 is a reply to message #473193] |
Thu, 26 August 2010 11:14   |
sathik
Messages: 196 Registered: August 2009 Location: INDIA
|
Senior Member |
|
|
so I need to execute the any one of below query to resize the RBS_A tablespace.
alter database datafile '/u05/oradata/WFLOW/rbs_a_01.dbf' resize 3000;
alter tablespace RBS_A add datafile '/u05/oradata/WFLOW/rbs_a_03.dbf' size 1000M;
I thought, resizing the rollback segment will not be same task as resizing the undo tablespace in oracle 9i.
and also can I drop this new datafile after completing the import activity?
|
|
|
|