Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DataPump Import
Graham
Did you trace the session? A work around would be to import the table
into another schema (do data validation if any) , then insert into the
actual schema
I am wondering what is preventing importing of data. Were any trace
files created? Did you check alert.log?
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-lReceived on Tue Jul 24 2007 - 09:55:29 CDT
![]() |
![]() |