Terry Dykstra <tdykstra_at_cfol.ab.ca> escribió en el mensaje de noticias
56fx4.2507$NU5.160374_at_news0.telusplanet.net...
> Once you've set the block size, you cannot change it anymore.
> If you have a primary key on the table, you cannot duplicate the rows,
> whatever method you choose. You will need to drop that index.
> The easiest way is to do a simple
>
> insert into x
> select * from x;
>
> This will only work though if you have 'normal' datatypes. If you have
for
> instance a column defined as a long, this will not work.
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> Check out Sybase Developer's Network: http://www.sybase.com/sdn
>
> <crudmucosa_at_my-deja.com> wrote in message
> news:8a3sbr$9to$1_at_nnrp1.deja.com...
> > Folks,
> >
> > I am trying to export data from a table, then import that data back
> > into the table (thus doubling the amount of records in the table). I've
> > used the export function (with the INDEXES=N paramater to keep the
> > primary keys from being duplicated). When I tried to import the data, I
> > got a block size error (said it was too small), then an abend.
> >
> > I thought that I could just edit the db_block_size = 2048
> > param my database's pfile to something larger (I tried 4096), restart
> > the database, and try the import again. HOwever, once I change the
> > block size, the database will not start.
> >
> > Any ideas? Am I going about this all wrong?
> >
> > --Desmond
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Tue Mar 07 2000 - 00:00:00 CST
