While Importing use INDEXFILE with show=y option. It will create CREATE
TABLE and CREATE INDEX commands in a file. All CREATE TABLE statements
will be commented out with REM. vi that file and delete all the occurrences
of "REM" s at the beginning of a line using "1,$ s/^REM//" in vi. You
can create tables and indexes using this file without removing double
quotes. You may also want to check for any unwanted lines in this file,
delete them if you find any.
--
Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX
Rich Richardson <richard_richardson_at_ps.net> wrote in article
<32DCE5C1.2891_at_ps.net>...
> 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?
>
> 1. Export database structure without rows
> 2. 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
