Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: DataPump Import

GovindanK

2007-07-24

Replies:

Graham

Did you trace the session? Did you check the log? Were any trace files
created? I am wondering what could be causing this. May be you can try
importing to a different schema and then insert from there.

HTH
GovindanK

Graham Ross wrote:
> All,
>
> I just need a sanity check . . . .
>
> Is there any reason why I can't import data into a table using datapump while the database is in use ?  The import is historical data moved from another system which will be accessed infrequently.  The table itself receives inserts, but no updates or deletes (except for a daily purge job).
>
> Ideally I'd prefer to do it with all the users out of the sytem, but this isn't possible at the moment.  The only thing I could think of would be a possible performance hit, but we aren't unduly stressing the system at the moment.
>
> thanks in advance,
>
> graham
>
>
>     ___________________________________________________________
> Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
> now.
> http://uk.answers.yahoo.com/
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
>  

--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.