Fragmented tables with ROWID's and HPL
Peter asked how to use the High Performance Loader (onpload) to load an HPL unload file into a table that is fragmented and has ROWIDs added, since every attempt produced errors (including one error per row in deluxe mode). Art Kagel's workaround was to DROP ROWIDS, run the HPL load, then ADD ROWIDS again — which works but the ALTER TABLE steps are very slow. Art's HPL expert suggested the failure is caused by a mismatch between the hidden rowid column in the table and the columns present in the data file. No faster or definitive fix is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
How do I configure HPL to import an HPL generated unload file into a table that is now fragmented with rowid's? Everything I have tried just gives me errors. Thanks Peter
ALTER TABLE ... DROP ROWIDS; <hpload> ALTER TABLE ... ADD ROWIDS; Art S. Kagel ----- Original Message ----- From: Peter J Dia.... <ids@iiug.org> At: 8/16 10:02:57 How do I configure HPL to import an HPL generated unload file into a table that is now fragmented with rowid's? Everything I have tried just gives me errors. Thanks Peter ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Art, Yeah, I should have mentioned that I do that, and is does work. Its just the alter is sloooooowwwww. Any other ways? Thanks Peter ART KAGEL, .... wrote: > ALTER TABLE ... DROP ROWIDS; > <hpload> > ALTER TABLE ... ADD ROWIDS; > >
HPLoader fails even in deluxe mode? I thought it's just doing INSERTS in that mode and so should work. I'll ask my resident HPLoader expert and let you know what he says. Art ----- Original Message ----- From: Peter J Dia.... <ids@iiug.org> At: 8/16 10:12:44 Hi Art, Yeah, I should have mentioned that I do that, and is does work. Its just the alter is sloooooowwwww. Any other ways? Thanks Peter ART KAGEL, .... wrote: > ALTER TABLE ... DROP ROWIDS; > <hpload> > ALTER TABLE ... ADD ROWIDS; > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
OK, he thinks that maybe onpload is detecting the extra hidden column in the
table but doesn't see the data for it in the data file (or vice-versa) so this
mismatch is causing the problem.
Art
----- Original Message -----
From: Art Kagel <ids@iiug.org>
At: 8/16 10:14:30
HPLoader fails even in deluxe mode? I thought it's just doing INSERTS in that
mode and so should work. I'll ask my resident HPLoader expert and let you know
what he says.
Art
----- Original Message -----
From: Peter J Dia.... <ids@iiug.org>
At: 8/16 10:12:44
Hi Art,
Yeah, I should have mentioned that I do that, and is does work. Its
just the alter is sloooooowwwww.
Any other ways?
Thanks
Peter
ART KAGEL, .... wrote:
> ALTER TABLE ... DROP ROWIDS;
> <hpload>
> ALTER TABLE ... ADD ROWIDS;
>
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Yeah, I tried deluxe mode as well and I received and error for every row in the file to be loaded into the fragmented table. Thanks Peter ART KAGEL, .... wrote: > HPLoader fails even in deluxe mode? I thought it's just doing INSERTS in that > mode and so should work. I'll ask my resident HPLoader expert and let you know > what he says. > > Art > ----- Original Message ----- > From: Peter J Dia.... <ids@iiug.org> > At: 8/16 10:12:44 > > Hi Art, > > Yeah, I should have mentioned that I do that, and is does work. Its > just the alter is sloooooowwwww. > Any other ways? > > Thanks > Peter > > ART KAGEL, .... wrote: > >> ALTER TABLE ... DROP ROWIDS; >> <hpload> >> ALTER TABLE ... ADD ROWIDS; >> >> >> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >