jjreimer_at_wthg.com wrote:
>
> I sometimes need to copy every object (tables, indexes, views, sequences,
> triggers, packages, procedures,...) for a schema from a production
> database to a test database. I can't pull the actual data because the
> test instance is too small to hold it all.
>
> The problem is that the create table (and index) statements in the export
> file have the sizes of the production database. I would like to change
> these sizes or eliminate them so the default storage size for the
> tablespaces would be used.
>
> I can do this for the indexes using the indexfile keyword on import, then
> editing the file. I have not been able to modify the storage clause for
> the tables.
>
> Does anyone know how I could accomplish this? Or, has anyone been able
> use an editor on the export file without corrupting the file? If so,
> which editor?
>
> John Reimer
> DBA
> Worthington Steel
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Hi John,
The same file created using the indexfile parameter on import has all
the table definitions also. Remove the REM in front of each line and
modify the initial, and next storage parameters. You can also change
the tablespace name if you wish. Extract the table definitions to a
seperate file and run it on your test system.
Another method is to use the unix strings command against the dump file
and writing to a text file. You will need to edit the file for line
length such as insert returns at appropiate spots to keep line length to
less than 80 characters.
Hope this helps.
Dick
Received on Fri Sep 26 1997 - 00:00:00 CDT
