Help with pseudo rowid!!
Hi all!
I was trying to load pipe delimited data from a table (the source),
using onpladm onto another table (the target), when I got this error:
Error occured at HPL failpoint: 16305
Cannot perform express mode load on table with pseudo rowid
Error occured at HPL failpoint: 16115
(yeah, yeah, I was able to load the data with deluxe mode...)
I got the schema for both tables, I noticed that the target table was
created with the "with rowids" option (yes it is fragmented, and yes,
after inquiring around, I found out that the previous DBA created the
table like that.). The source table is not fragmented and it was
created with default values (just the column definition and nothing
else).
The question is: is there a way to inquiry the SMI to find out if a
table (fragmented or not) was created with the "with rowids" option?
if so, which table is it? I looked hi and low thru systables and
syscolumns in the database where the table resides and nothing.
Any help would be appreciated.
BTW, I'm runnning IDS 11.10.FC3 on SunOS 5.10 (Solaris 10).
Thanks in advance!
Ramón
====================================
"Any man who can drive safely while kissing a
pretty girl is simply not giving the kiss the
attention it deserves."
Albert Einstein
you could ask dbschema how it's found:
export SQIDEBUG=2:/tmp/somefile
dbschema -d <name of db> -t <name of your table> -ss
then use sqliprint (comes with csdk) on /tmp/somefile*
for what it's worth in sysfragments you will find if a table is
fragmented or not,
dono yet where 'with rowids' is stored yet...
Superboer.
On 2 sep, 21:16, fandelau <fande...@gmail.com> wrote:
> Hi all!
> I was trying to load pipe delimited data from a table (the source),
> using onpladm onto another table (the target), when I got this error:
>
> Error occured at HPL failpoint: 16305
> Cannot perform express mode load on table with pseudo rowid
> Error occured at HPL failpoint: 16115
>
> (yeah, yeah, I was able to load the data with deluxe mode...)
>
> I got the schema for both tables, I noticed that the target table was
> created with the "with rowids" option (yes it is fragmented, and yes,
> after inquiring around, I found out that the previous DBA created the
> table like that.). The source table is not fragmented and it was
> created with default values (just the column definition and nothing
> else).
>
> The question is: is there a way to inquiry the SMI to find out if a
> table (fragmented or not) was created with the "with rowids" option?
> if so, which table is it? I looked hi and low thru systables and
> syscolumns in the database where the table resides and nothing.
>
> Any help would be appreciated.
>
> BTW, I'm runnning IDS 11.10.FC3 on SunOS 5.10 (Solaris 10).
>
> Thanks in advance!
>
> Ramón
>
> ====================================
> "Any man who can drive safely while kissing a
> pretty girl is simply not giving the kiss the
> attention it deserves."
> Albert Einstein