DataPump Import

From: Graham Ross <grahamaross_at_yahoo.com>
Date: Mon, 23 Jul 2007 03:24:37 -0700 (PDT)
Message-ID: <109000.36786.qm@web63915.mail.re1.yahoo.com>

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

Received on Mon Jul 23 2007 - 05:24:37 CDT