Home » RDBMS Server » Server Utilities » expdp (10.2.0.3.0)
expdp [message #425285] Thu, 08 October 2009 07:05 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member

Hi,

I have started the expdp.
Later i come the error as:
statement in resumable session 'SMSMAIN.FULL_EXPORT.1' was suspended due to
ORA-01654: unable to extend index SMSMAIN.SYS_MTABLE_0000214F7_IND_1 by 128 in tablespace SMSMAIN

I resize the datafile
after that expdp is not running:
giving msg in alert log as:
The value (30) of MAXTRANS parameter ignored.

Before that i noticed msg in alert log as:
statement in resumable session 'SMSMAIN.FULL_EXPORT.1' was timed out

shall i have to drop master table :"SMSMAIN.FULL_EXPORT"

Thanks
Re: expdp [message #425294 is a reply to message #425285] Thu, 08 October 2009 07:25 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>The value (30) of MAXTRANS parameter ignored.

You can ignore this message.

Quote:
>>ORA-01654: unable to extend index SMSMAIN.SYS_MTABLE_0000214F7_IND_1 by 128 in tablespace SMSMAIN


Increase your SMSMAIN tablespace size.

>>shall i have to drop master table :"SMSMAIN.FULL_EXPORT"

No. Start with different job name.

-Babu
Previous Topic: Errors Migrating from oracle 9i enterprise edition to oracle 10g r2 standard
Next Topic: Drop cascade impact to index and user permissions roles
Goto Forum:
  


Current Time: Sat Dec 10 20:35:51 CST 2016

Total time taken to generate the page: 0.25895 seconds