| received ora-30036 [message #244582] |
Wed, 13 June 2007 07:41  |
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 #244630 is a reply to message #244623] |
Wed, 13 June 2007 09:48  |
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 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
