Re: newbie question about to small rollback segment

"@nnibale" <annibale_at_ifrance.com> wrote in message news:9a7n9h$pkd$1_at_reda.worldonline.fr...
> hi,
>
> I've made an export full of my oracle 7.1.3 database (30 go).
> My export fail due to rollback segment to small.
>
> my command was :
> exp user/pwd commit=y ignore=y ....
>
> What can I do ?
>

Er..... make your rollback segment bigger???

Er..... try and post more informative messages on the newsgroup?????

Do you mean you had an ORA-1555 Snapshot too old error? And were you trying to export with consisitent=Y??

Because if the answer to the first question is yes, you can 1) make rollback segments bigger or 2) shutdown the database and then open it in restricted session mode so that there are no real users on the system or 3) run export at 2 o'clock in the morning when OLTP activity on the database is at a minimum. Option 1 is not a guarantee that the same problem won't happen again. Neither is option 3. Option 2 will guarantee it, however.

And if the answer to the second question was yes, stop trying to make your exports globally consistent on a heavily-transacted database, because you are simply asking for trouble.

Regards
HJR
> Thanks.
> Regards.
> @nnib very new in the g_at_me.
>
>
>
>
Received on Sun Apr 01 2001 - 15:43:54 CDT