467,168 Members | 970 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,168 developers. It's quick & easy.

multi-file multi-table import


Please help me with this scenario:

Problem :
I have around 10 tables(having relationship with each other) and a data
asc file for each. i use import utility to load all the data one by one
for each table...these files are almost 1gb each. I need to commit data
only when all the 10 table imports are done as the data is relational
dependant , not after each table import is finished as the import
commits as it is done with the inserts/updates for one table...

please advice.

Mar 23 '06 #1
  • viewed: 991
2 Replies
use a storage procedure,but you'll have very very poor performence.

why not firstly drop the relationship, import one by one, then use a
procedure to check the relationship, rebuild the relationship? does the
data be cleaned?

Mar 23 '06 #2
The tables are in use by the users so can drop relationships, Can i
use import in stored procedure.? or if these all imports can be clubbed
in a transaction. The data is not cleaned it either inserted or
updated(using insert_update option of import)

Mar 23 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Stian Søiland | last post: by
reply views Thread by Sven Erik Matzen | last post: by
1 post views Thread by David Isaac | last post: by
12 posts views Thread by Pollux | last post: by
3 posts views Thread by Lord2702 | last post: by
2 posts views Thread by avenpace@gmail.com | last post: by
1 post views Thread by huwjeffries@gmail.com | last post: by
7 posts views Thread by Ron Adam | last post: by
1 post views Thread by =?Utf-8?B?aWduaGVucnk=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.