multi-file multi-table import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sanyog - 23 Mar 2006 10:30 GMT

Hi

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.

Reply to this Message

Hardy - 23 Mar 2006 11:32 GMT

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?

Reply to this Message

sanyog - 23 Mar 2006 15:04 GMT

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)

Reply to this Message