Home » RDBMS Server » Server Utilities » received ora-30036
received ora-30036 [message #244582] Wed, 13 June 2007 07:41 Go to next message
moody1
Messages: 15
Registered: March 2007
Junior Member
Hello. I'm importing a pretty good size dmp file and have received an ora-30036. I've increased the rbs. I am importing one table that is partitioned and subpartitioned. Does this mean I have to the start import over? Thanks for your help and patience.

[Updated on: Wed, 13 June 2007 07:44]

Report message to a moderator

Re: received ora-30036 [message #244623 is a reply to message #244582] Wed, 13 June 2007 09:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think we know what is ora-30036?
Don't you think posting your import command may help us help you?
What about posting your Oracle version (4 decimals)?

Regards
Michel
Re: received ora-30036 [message #244630 is a reply to message #244623] Wed, 13 June 2007 09:48 Go to previous messageGo to next message
moody1
Messages: 15
Registered: March 2007
Junior Member
Sorry. The ora-30036 is a roll back segment to small error.
Here is the import command:
#!/bin/sh

###########

export ORACLE_HOME=/oracle/app/oracle/product/9.2.0
export PATH=$ORACLE_HOME/bin:$PATH:.
export ORACLE_SID=biwhse

${ORACLE_HOME}/bin/imp userid=xxxxx/xxxxx \
file=/oradmp/upcact0706120810.dmp buffer=1000000 \
log=/oradmp/upcactimp.log \
rows=y ignore=y fromuser=item_hist

oracle version is 9.2.0.6

Thanks.
Re: received ora-30036 [message #244654 is a reply to message #244630] Wed, 13 June 2007 11:23 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ora-30036 is a roll back segment to small error

Wrong! Please, post correct and complete information if you want we help you.
ora-30036: unable to extend segment by %s in undo tablespace '%s'
 *Cause:   the specified undo tablespace has no more space available.
 *Action:  Add more space to the undo tablespace before retrying
           the operation. An alternative is to wait until active
           transactions to commit.


So:
- add more space to undo tablespace
- add commit=y to your import command

Regards
Michel
Previous Topic: Problem SQL Loading a delimited file into two different tables? Please Help!
Next Topic: SQL Loader - load a file with a fixed value passed as parameter
Goto Forum:
  


Current Time: Sat Dec 03 17:57:08 CST 2016

Total time taken to generate the page: 0.05374 seconds