Re: Importing and Exporting data

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.