OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » expdp (10.2.0.3.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

expdp [message #425285]

Thu, 08 October 2009 07:05

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

Report message to a moderator

Re: expdp [message #425294 is a reply to message #425285]

Thu, 08 October 2009 07:25

babuknb
Messages: 1736
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:35:42 CST 2024