for precreatng the users, pull the create users statements out
of the .dmp file.
joe
>>> [EMAIL PROTECTED] 07/05/01 02:35PM >>> So, We're taking the leap from 8.0.6 to 8.1.7. For various reasons, we will be using the export/import method of migration. Since I'll have the DB all to myself for the weekend, I want to also partition 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 a clean DB? Did you just manually precreate the schemas? How does the import deal with this (e.g. the DESTROY arg for imp)? Or would it be OK to skip step 4 and delete/rebuild the tables to be partitioned after the import had rebuilt them? I would prefer not to do the latter, seeing as this will be the 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 much time to plan for that... :( TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 also send the HELP command for other information (like subscribing). |
- How to precreate tables for migration? Jesse, Rich
- Re: How to precreate tables for migration? Don Jerman
- RE: How to precreate tables for migration? JOE TESTA
- RE: How to precreate tables for migration? Jesse, Rich
- Re: How to precreate tables for migration? Binley Lim