By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

multi-file multi-table import

P: n/a

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
Share this Question
Share on Google+
2 Replies

P: n/a
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

P: n/a
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.