for precreatng the users, pull the create users statements out
of the .dmp file.
joe
>>> Rich.Jesse_at_qtiworld.com 07/05/01 02:35PM
>>>So,We're taking the leap from 8.0.6 to 8.1.7. For
various reasons, we will beusing the export/import method of
migration.Since I'll have the DB all to myself for the weekend, I want
to alsopartition most of our larger tables (1M-7M rows each -- it's not a
huge DB)in the migration. My plan to precreate the tables was
to: 1) Export
DB. 2) Create new 8.1.7
DB. 3) Create
tablespaces. 4) Create partitioned
tables. 5) Import
DB. (I've left out many migration steps not pertinent
to this question)Obviously, step 4 can't go before step 5, as step 5
creates the schemas.So, my questions: Has anyone precreated tables
before a full import on aclean DB? Did you just manually precreate the
schemas? How does the importdeal with this (e.g. the DESTROY arg for
imp)? Or would it be OK to skipstep 4 and delete/rebuild the tables to
be partitioned after the import hadrebuilt them? I would prefer not to
do the latter, seeing as this will bethe first time in three years that the
TSs will be nice and contiguous. :)Also, for brevity, we won't be
going LMT for most of our TSs. Need too muchtime to plan for
that... :(TIA!Rich
Jesse
System/Database
AdministratorRich.Jesse_at_qtiworld.com
Quad/Tech International, Sussex, WI USA-- Please see the official
ORACLE-L FAQ:
http://www.orafaq.com--
Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.comFat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Thu Jul 05 2001 - 13:11:37 CDT
