RE: Export/Import Job
Exporting an individual schema within APPS (GL /PA etc) is not recommended due to the number of constraints that cross schemas (to fnd tables for instance). So changing the block size is essentially non Apps specific and is just a straight export /import. Depending on your hardware and plan I would have expected you to be able to start on a Saturday and complete on Sunday (sometime). Run as much archiving/purging as you can (certainly tables like fnd_requests should be tidied down as much as possible). Have a few dummy runs so that the the scripts are all fully tested and you have a good checklist of all the scripts and expected timings. Most importantly of all ensure that you can revert back from your backup safely and as quickly as possible. Hopefully you will have the space to pre-create the instance (dummy sid) and then rename it once you have completed the export of live (Come to think of it, if you have that space you can retain both instances and that certainly helps if you decide to abandon the build or revert for any reason) PS Unless the database really needs re-building what other benefits do you expect from changing the block size? HTH John -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: 30 November 2001 21:05To: Multiple recipients of list ORACLE-LSubject: Export/Import Job If anyone out there has a good time estimate for the following export/import job I would appreciate it. The goal is to change the DB_BLOCK_SIZE. Application: Oracle Apps 11i Database Size: 100GB, actually only about 80GB is used space. 2 CPU HP L-Class machine. I just need a couple of good estimates of how many days/hours this will take. I'm guessing around 3 days... but I have never done anything this large before. Thanks!! Nick >> This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. >>
RE: Export/Import Job
Nick, Export/Import on an Oracle Apps database is not very well supported. It is my understanding (from another list) that a bug (or is that a feature :) currently exists. This may not be applicable in your situation. A loss of Java objects has been reported. Keeping in mind that Quest may need to know about this for a testing scenario, this may be Ok, but not if you want the Apps database to work from a logical point of view Nick, if you would to like to follow this up, join the OAUGnet-DBA list at 'www.oaug.net' via the Web ans search for the thread 'RE: export/import of 11i database - fyi update'. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Kill your killer-commute! Listen to great commercial-free christian music 24x7 (details at www.klove.com) ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Friday, November 30, 2001 1:05 PM To: Multiple recipients of list ORACLE-L If anyone out there has a good time estimate for the following export/import job I would appreciate it. The goal is to change the DB_BLOCK_SIZE. Application: Oracle Apps 11i Database Size: 100GB, actually only about 80GB is used space. 2 CPU HP L-Class machine. I just need a couple of good estimates of how many days/hours this will take. I'm guessing around 3 days... but I have never done anything this large before. Thanks!! Nick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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).
