Home » RDBMS Server » Server Administration » query required (oracle 8i)
query required [message #473191] Thu, 26 August 2010 11:04 Go to next message
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 #473193 is a reply to message #473191] Thu, 26 August 2010 11:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
01650, 00000, "unable to extend rollback segment %s by %s in tablespace %s"
// *Cause:  Failed to allocate an extent of the required number of blocks for
//          a rollback segment in the tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//          files to the tablespace indicated.
Re: query required [message #473197 is a reply to message #473191] Thu, 26 August 2010 11:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Since I am new to oracle 8i, can u give me the query to do the below activity?

Database SQL Reference
Ctl-F ROLLBACK

Regards
Michel
Re: query required [message #473199 is a reply to message #473193] Thu, 26 August 2010 11:14 Go to previous messageGo to next message
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?
Re: query required [message #473201 is a reply to message #473199] Thu, 26 August 2010 11:18 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I've forgotten more about V8 than I remember.
Sad

When all else fails, Read The Fine Manual

http://www.oracle.com/pls/tahiti/tahiti.docindex
Previous Topic: ora 11gR2 installation
Next Topic: Generation of redo log file
Goto Forum:
  


Current Time: Fri Nov 29 08:45:46 CST 2024