Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export / import of a db
DA Morgan wrote:
> DMina_at_laiki.com wrote:
>
>> The database size is approximately 58GB (used space) and the exported >> dump file is 28GB
Here's a modification of the above, which has some benefits in terms of minimizing overhead inside the database (the data only gets written inside the new database once, instead of twice).
Create a second export with ROWS=n, import it and move everything around as above (fast because all the tables have zero rows), and then import the first, data-laden export with IGNORE=y.
Or alternately, using the same ROWS=n export, run IMP with the INDEXFILE option. This will put out a text file with all your index and (commented) table creation statements. You then edit this file to use the new storage parameters (probably no harder than coming up with all the "ALTER [table|index] MOVE" statements you would need otherwise) and then run this file to pre-create all your tables (empty) and indexes in the correct location. Then import the data with IGNORE=y.
Since you asked what else to keep in mind:
Breaking the task into smaller steps make it easier to test, easier to reproduce, and easier to re-start if interrupted.
-Mark Bole Received on Tue May 31 2005 - 17:53:23 CDT