Subject | Importing From External File |
---|---|
Author | Mike Grover |
Post date | 2001-08-17T13:04:49Z |
Well I split my 2 large SDF Data files into files 5 million records each.
Total size of all files was 38 gig.
I then setup tables to external files.
Next I Imported from each table like this..
INSERT INTO EXPERIAN SELECT * FROM EXPA;
COMMIT;
INSERT INTO EXPERIAN SELECT * FROM EXPB;
COMMIT;
INSERT INTO EXPERIAN SELECT * FROM EXPC;
COMMIT;
It finished with out errors...
Problem is that the total of all gdb files is 26 gig?
I wonder what data is missing?
mike...
Total size of all files was 38 gig.
I then setup tables to external files.
Next I Imported from each table like this..
INSERT INTO EXPERIAN SELECT * FROM EXPA;
COMMIT;
INSERT INTO EXPERIAN SELECT * FROM EXPB;
COMMIT;
INSERT INTO EXPERIAN SELECT * FROM EXPC;
COMMIT;
It finished with out errors...
Problem is that the total of all gdb files is 26 gig?
I wonder what data is missing?
mike...