Question Regarding Importing Tables and Modifying Table Creation Defaults

From: Rich Richardson <richard_richardson_at_ps.net>
Date: 1997/01/15
Message-ID: <32DCE5C1.2891@ps.net>#1/1

Is anyone familiar with the following situation?

I am converting an Oracle Database from NT to UNIX. Normal migration through exports and script verification works fine.

I have one issue:

I need to modify the default freelist values as they currently will not support the size of the database without some blocking contention. Without having to export rebuild and import each table is there a script or method out there that will allow me to do the following procedure?

Export database structure without rows
Import the structure with show and log so that the script for ddl now exists.

Here is the part I need:

3. I can modify the freelist value with sed, I need to find a script to format the rest of the SQL code for execution.

	This would be to remove the quotes and to also know when
	a SQL block has completed and place a semicolon at the end.

I thought I would post this question in hopes that this is already out there or possibly someone may have a better answer.

Thanks Rich. Received on Wed Jan 15 1997 - 00:00:00 CST