RE: Exp/Imp and old storage clauses

Hi Ken,

Why not just use locally managed tablespaces with a UNIFORM extent management policy. Your old storage clauses will just be ignored.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
From: Fowler, Kenneth R [mailto:kenneth_r_fowler_at_groton.pfizer.com] Sent: Friday, 17 November 2000 6:37
To: Multiple recipients of list ORACLE-L Subject: Exp/Imp and old storage clauses

List,

I have been migrating a few database to 8.1.6 (from 7.n.n) on Solaris lately and when I do this I have been using exp/imp so that I can apply some of the storage strategies outlined in the "How To Stop Defragmenting and Start Living" document. The basic method I am using is...

1. Create new empty database that have tablespaces with appropriate default storage clauses (initial extent, next extent as per the doc's suggestions etc etc).
2. Perform full export of old database.
3. Use imp .... indexfile = filename.sql to extract sql for tables, indexes and constraints.
4. Use a nasty sed script I put together to process the above extracted sql to rip out all of the storage clauses defined at object level and change tablespace clause to whatever I want etc
5. Create the tables from sql generated in step 3 and 4.
6. Import row data into the preexisting tables
7. Create indexes, constraints from sql generated in step 3 and 4.
8. Perform a final import (ignore = y) to import grants and any other stuff I may have missed (should hopefully not be anything).

This is quite tedious, especially all of the checking I need to do to verify that the sed script works as desired. Anyone know of an easier/better way to import objects and default to the tablespace storage clause (that is, leave off the object storage clause!).

I would really love import to have a switch that would do this for me. Anyone else find themselves jumping through the same hoops?????

	Ken


	(Kenneth R Fowler)

	(860) 732 0026 (Voice)

	(860) 732 3689 (Fax)

	(860) 715 8346 (Fax to Email)

	(860) 599 8791 (Fax @ Home)

	Clinical Systems DBA Support
	Kenneth_R_Fowler_at_groton.pfizer.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fowler, Kenneth R
  INET: kenneth_r_fowler_at_groton.pfizer.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may