Importing and Exporting data

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