Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |