Re: Add datafile to a tablespace while EXP utility is running?

I just wanted to add that there are no inserts happening while the EXP is dumping the database. The ORA-1683 s happened yesterday night - which we noticed now while the scheduled EXP had started running.

I need to add the datafile now so that when the scheduled data import happens at midnight - it should get in without any more ORA-1683s.

Hence I need to be sure that the backup being taken by EXP will not be compromised if I add a datafile now while EXP is running.

"Jean-Marc Pietrzyk" <map_splc_at_wanadoo.fr> wrote in message news:b13jfu$1ts$1_at_news-reader12.wanadoo.fr...
> Configuration: WinNT SP6, Oracle 8.1.7 EE.
>
> Issue: Would there be any undesirable side effects if I execute a few
'ALTER
> TABLESPACE ADD DATAFILE' to allocate additional space to some partitions
> while a full database backup (using EXP utility) is going on?
> For our database the EXP usually takes 8-10 hours to finish. And I would
> like to allocate additional datafiles because we need to fix some
"ORA-1683:
> unable to extend index <stringA> partition <stringB> by 128 in tablespace
> <stringC> that we were getting earlier
>
> Any help would be greatly appreciated.
>
> Thanks
>
>
>
Received on Mon Jan 27 2003 - 11:17:47 CST